asked
How to write merge statement inside another merge statement?
How to write merge statement inside another merge statement? please see the below logic. merge into table1 ---- when not matched merge into table2 --- when not matched insert into table1 matched update table2 matched update table1 Please help me to write the query. Thanks in advance. varath..
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
Hi, I have written code snippet for merge statement inside the condition of another merge statement. i am not able to write exact code here. i am facing syntax error near second merge. can you please provide some samples for two merge in one store procedure? code : Declare @variable declaration Merge Into Using (select query) On When not matched then Merge into Using (select query) On When not matched then Insert into records Matched Update records Matched Update records
I had a few thoughts about this. 1. a `MERGE` statement has only one target 2. You can't use the output from a `MERGE` statement as the input to a `MERGE` statement 3. And anyway, the output from a `MERGE` statement of the type you would generate wouldn't contain the rows you want to merge into your secondary table 4. You could capture the output from the MERGE / INSERT, and then run a second MERGE which only looks at items from your input table that don't appear in the previous merge output... 5. ...and now I've got a headache So, what you want might not be possible in the way that you want. I can see why you might want to do this, though.
20 People are following this question.
