Merge

Question

Post reply

Merge

okbangas

SSChampion

Points: 11773
More actions
February 13, 2013 at 9:38 pm

#274132

Comments posted to this topic are about the item Merge

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter
Concatenating Row Values in Transact-SQL[/url]
February 14, 2013 at 3:13 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 39 total)

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

Nice question Kristian! Thanks 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 2

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Good question. I learn something new !!!

Thanks

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Gazareth One Orange Chip Points: 27737 More actions · Answer 4

Gazareth

One Orange Chip

Points: 27737

February 14, 2013 at 2:43 am

#1587780

Nice question, thanks

siddharth.tandon1 SSC Journeyman Points: 95 More actions · Answer 5

siddharth.tandon1

SSC Journeyman

Points: 95

February 14, 2013 at 3:13 am

#1587791

Nice question on merge!

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 6

(Bob Brown)

SSCrazy

Points: 2705

February 14, 2013 at 4:11 am

#1587819

Thank you for the question and lesson.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Thanks for the question, Ole. Interesting.. (before I knew very little about the merge, but know even little bit more... 🙂 )

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

mtassin SSC-Insane Points: 23099 More actions · Answer 8

Good question, learned something I didn't know about Merge and I use it not every day, but at least every other week. 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

sestell1 SSChampion Points: 10230 More actions · Answer 9

Ugh, apparently I really need to use MERGE more often.

Thanks for the great question!

BarbW SSCarpal Tunnel Points: 4759 More actions · Answer 10

What's Merge got to do with Valentine's Day?? 😉 Just kidding, good question!

Venkat Jonnalagadda Mr or Mrs. 500 Points: 510 More actions · Answer 11

Great question... learnt something new today..! Thanks for the qotd

___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Nice question. However, the explanation would have been better if it had pointed out that filters like this can be placed in the when matche/not matched conditions. In this merge statement the when clause should have been when not matched by target and src.RowNo = 1 if the intention was to get only the three rows with RowNo 1.

In fact even filtering of the target table in the on clause other than with a matching codition between source and target is stated by MS to be bad practice, as it can lead to unexpected results (ie it doesn't necessarily do what you would expect it to do).

BoL
It is important to specify only the columns from the target table that are used for matching purposes. That is, specify columns from the target table that are compared to the corresponding column of the source table.

Tom

jmoney 69422 SSC Enthusiast Points: 151 More actions · Answer 13

Terrific and subtle point. You got me. Any "filtering" must be done in the WHEN [NOT] MATCHED AND xxx clause.