sqlfriends (8/23/2012)
So in the merge statement, Right below when matched statement I can add where not exists like below ? Thanks
Don't just copy and paste, read the article and understand it! You have an extra 'WHERE' that would cause a syntax error. I'm amazed you replied without trying it first.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi