SQL 2008 T-SQL

Question

Post reply

SQL 2008 T-SQL

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

dave.farmer SSCrazy Points: 2431 More actions · Answer 1

Jamie Longstreet (8/21/2009)

Excellent question.

First because it demonstrates the MERGE,

Second because it illustrates the $action,

Nice one!

Actually, I was going to say much the same but got a bit sidetracked by the answer confusion... I didn't know about MERGE before but thanks to this QotD it's clear how it works and it will be most helpful in solving a problem I have at work without resorting to extra and less efficient processing.

Cheers!

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

Jamie Longstreet (8/21/2009)

--------------------------------------------------------------------------------

Excellent question.

First because it demonstrates the MERGE,

Second because it illustrates the $action,

Nice one!

dave.farmer

Actually, I was going to say much the same but got a bit sidetracked by the answer confusion... I didn't know about MERGE before but thanks to this QotD it's clear how it works and it will be most helpful in solving a problem I have at work without resorting to extra and less efficient processing.Cheers!