UPDATE r1 SET r1.ParameterValue = r2.ParameterValue FROM dbo.ReportViewSourceParameter_old r1 JOIN dbo.ReportViewSourceParameter r2 ON r1.ParameterKey = r2.ParameterKey AND r2.SourceID = r1.SourceId GO INSERT INTO ReportViewSourceParameter_old (SourceID, ParameterTypeCode, ParameterKey, ParameterIndex, ParameterValue, DocumentID, UserVisible, InheritChildSourceFilters) SELECT r2.SourceID, r2.ParameterTypeCode, r2.ParameterKey, r2.ParameterIndex, r2.ParameterValue, r2.DocumentID, r2.UserVisible, r2.InheritChildSourceFilters FROM ReportViewSourceParameter r2 WHERE NOT EXISTS (SELECT * FROM ReportViewSourceParameter_old WHERE ParameterKey = r2.ParameterKey AND SourceID = r2.SourceID) GO EXEC sp_rename 'ReportViewSourceParameter', 'ReportViewSourceParameter_temp_build_20170221' GO EXEC sp_rename 'ReportViewSourceParameter_old', 'ReportViewSourceParameter'