I have a source table and Destination tableinitailly i have loaded some data into destination table through some conditions Target.col1 = Source.col1AND Target.col2 = Source.col2MERGE INTO dbo.TestDestination AS TargetUSING ( select col1,col2,col3,col4 from testsource ) AS Source ON Target.col1 = Source.col1 AND Target.col2 = Source.col2 WHEN MATCHED THEN UPDATE SET Target.col1 = Source.col1, Target.col2 = Source.col2, Target.col3 = Source.col3, Target.col4 = Source.col4 WHEN NOT MATCHED THEN INSERT ( [col1] ,[col2] ,[col3] ,[col4]) VALUES (Source.[col1] ,Source.[col2] ,Source.[col3] ,Source.[col4]);
but after that i added some more conditions like Target.col1 = Source.col1AND Target.col2 = Source.col2AND Target.col3 = Source.col3AND Target.col4 = Source.col4
then data will get filtered. So initial data is wrong data as per conditions so i need to delete initial data and load latest filtered data with these conditions.P.V.P.MOhan