Merge Targets

Question

Post reply

Merge Targets

September 9, 2014 at 4:28 am

This was removed by the editor as SPAM
September 9, 2014 at 5:36 am

This was removed by the editor as SPAM

Viewing 15 posts - 16 through 30 (of 46 total)

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Well, I hope Steve corrects the issue and awards points back.

I thought I lost my sanity there for a moment 🙂

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

Mauricio_ SSCrazy Points: 2935 More actions · Answer 2

I see I'm not the only one who checked Sales as valid answer. Now I feel better 🙂

martin.kelley Newbie Points: 7 More actions · Answer 3

martin.kelley

Newbie

Points: 7

September 9, 2014 at 2:07 am

#1744034

Answer is wrong!

Mighty SSCrazy Eights Points: 9063 More actions · Answer 4

Selected, as the most of us, the wrong correct answer.

Guess Steve was anticipating already the more complex MERGE question using a <target_table> option... 😀

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 5

Koen Verbeeck (9/9/2014)
Well, I hope Steve corrects the issue and awards points back.
I thought I lost my sanity there for a moment 🙂

agreed

AndrewJ_uk SSC Journeyman Points: 98 More actions · Answer 6

😀 Who else thinks Steve should lose 1000 points for that one?

Julio Jimenez SSC Veteran Points: 209 More actions · Answer 7

Julio Jimenez

SSC Veteran

Points: 209

September 9, 2014 at 4:50 am

#1744068

You owe me 1 point!! 😉

Umer Akram SSC-Insane Points: 22209 More actions · Answer 8

for a moment i was like :w00t:

I suppose script is not unit tested 😛

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

Stewart "Arturius" Campbell (9/9/2014)
Koen Verbeeck (9/9/2014)
Well, I hope Steve corrects the issue and awards points back.
I thought I lost my sanity there for a moment 🙂
+1 :hehe:

+1. But let's keep in mind that everyone makes mistakes once in a while.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SqlMel SSCrazy Points: 2901 More actions · Answer 10

Yep.

Somebody made a boo boo.

---------------
Mel. 😎

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

Stewart "Arturius" Campbell (9/9/2014)
Ed Wagner (9/9/2014)
Stewart "Arturius" Campbell (9/9/2014)
Koen Verbeeck (9/9/2014)
Well, I hope Steve corrects the issue and awards points back.
I thought I lost my sanity there for a moment 🙂
+1 :hehe:
+1. But let's keep in mind that everyone makes mistakes once in a while.
concur, have made a few epic ones in my time...

Yeah, I've done some real winners myself. Thankfully, we have point-in-time recovery. 😀

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Bob Razumich SSCrazy Points: 2155 More actions · Answer 12

Stewart "Arturius" Campbell (9/9/2014)
Ed Wagner (9/9/2014)
Stewart "Arturius" Campbell (9/9/2014)
Koen Verbeeck (9/9/2014)
Well, I hope Steve corrects the issue and awards points back.
I thought I lost my sanity there for a moment 🙂
+1 :hehe:
+1. But let's keep in mind that everyone makes mistakes once in a while.
concur, have made a few epic ones in my time...

+1

In other news, this is a sure sign the Apocalypse must be coming. So, since this is probably guaranteed to be the longest QOTD comment string in the history of QOTDs, I want to be a part of it. 😀

markusstar SSC-Addicted Points: 432 More actions · Answer 13

please correct the answer

it should be Sales that is updated/inserted into