USE ION_Data

UPDATE DataLog2
SET SourceID = (SELECT ID FROM Source WHERE Name = 'group_name.actual_source_name')
WHERE SourceID IN (SELECT ID FROM Source WHERE Name = 'group_name.misleading_source_name')