0

Say I want to compare my Source and Target Table using MERGE syntax in SQL

I want to update the End_Dt of my target table when target.close_Date is not equal to Source.Close_Date.

Table 1

ID   Close_Date   End_Date
1    NULL         9999-12-31 

Table 2

ID   Close_Date
1    2019-01-31 
Merge Table1 as Target
Using Table 2 as Source
On (Target.ID = Source.ID_)
WHEN MATCHED and 
isnull(Target.Closed_Date,'9999-12-31') = isnull(Source.Closed_Date,'9999-12-31')
THEN
Update Set Table1.End_Dt = cast(getdate() as date));

After I ran the code nothing is updated in my target table.

itajolosa
  • 1
  • 1
  • 3

0 Answers0