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?