Hi Friends,
Today I had a chance to write a Merge join statement using dynamic query for linked server. The statement goes like below
Merge into targettable TT
using (Select * from ..openquery(select * from sourcetable)) ST
on tt.Date = SR.Date
When Matched
Update
When Not Matched
Insert.
Today I had a chance to write a Merge join statement using dynamic query for linked server. The statement goes like below
Merge into targettable TT
using (Select * from ..openquery(select * from sourcetable)) ST
on tt.Date = SR.Date
When Matched
Update
When Not Matched
Insert.
No comments:
Post a Comment