ALZDBA (8/28/2013)
if that meets the requirement, it's ok.
But what abt the scenario for which I posted the question...
How can I implement this:
Scenario is: Currently if made any changes in DeviationRequestDetails a new row gets inserted into CLCProcessUnitDetailsCompany if it not exists previously. But now what I want is that if I made any change in column DeviationStatus of Source then only new rows should get inserted in Target else if changes made in any other column of Source then no rows should get inserted into Target.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/