Avatar of dgrafx
dgrafx
Flag for United States of America

asked on 

2 merge statements into 2 targets from 1 source

Sql server 2k8

I'm on my phone right now so I won't be posting code but can later if necessary
 
I have a source CTE (srccte) and a merge statement following it using a target (tgttbl) -
Works perfect !
I then wanted to add another target - a second table.  So I wrote another Merge statement after the first Merge statement and I get an error saying that SRCCTE is undefined.

Note that if I comment out either the first or the second MERGE statement the entire code works perfect - it's only when trying to use both that the error occurs.

How would one go about using a second target table? Would I use just one Merge statement and work the second table into the one statement?

Thanks
Microsoft SQL Server

Avatar of undefined
Last Comment
dgrafx

8/22/2022 - Mon