Merge Targets

I do, in fact, understand the MERGE statement, but for some reason checked the wrong box when I was picking the answer. The question and answer are on different tabs and I must have been multi-tasking poorly.

The answer has been corrected and points awarded back.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 5

Raghavendra Mudugal

SSChampion

Points: 10658

September 9, 2014 at 7:34 am

#1744116

Thanks for the post, SJ, nice one.

(I have read all the posts, and I see it; and I also wondered by seeing the score stats... what went wrong - see attached)

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

SQLRNNR SSC Guru Points: 281324 More actions · Answer 6

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 🙂

What little you had left?? :hehe::hehe::hehe::hehe::hehe::hehe:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Mauricio_ SSCrazy Points: 2932 More actions · Answer 7

Mauricio_

SSCrazy

Points: 2932

September 9, 2014 at 7:38 am

#1744119

I do, in fact, understand the MERGE statement, but for some reason checked the wrong box when I was picking the answer. The question and answer are on different tabs and I must have been multi-tasking poorly.

The answer has been corrected and points awarded back.

Good! But now we want 10 extra points 🙂

SQLRNNR SSC Guru Points: 281324 More actions · Answer 8

SQLRNNR

SSC Guru

Points: 281324

September 9, 2014 at 7:38 am

#1744120

Andy_J (9/9/2014)

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

Hahaha - lol

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281324 More actions · Answer 9

Steve Jones - SSC Editor (9/9/2014)

I do, in fact, understand the MERGE statement, but for some reason checked the wrong box when I was picking the answer. The question and answer are on different tabs and I must have been multi-tasking poorly.

The answer has been corrected and points awarded back.

You're a good man Steve. Thanks for all you do with the site and QOTD.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281324 More actions · Answer 10

sknox (9/9/2014)

This isn't a mistake. It's Steve's subtle way of getting us to write more questions:

http://qa.sqlservercentral.com/articles/SQLServerCentral/115420/

😀

Good point. I hope it is working:cool:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

stephen.long.1 SSCrazy Points: 2581 More actions · Answer 11

Thanks for the good question, Steve. I'm glad I didn't answer too early and lose my mind when my correct answer was marked as incorrect, like a lot of other people apparently did!

I don't think you should lose 1000 points for this mistake; only a few. :hehe:

Don't let this deter you from continuing to educate us on the MERGE statement. It's a complex subject that a lot of people don't completely understand.

I'm curious about the percentages, though. It states that 99% gave the correct answer and 1% gave the incorrect answer, but it also states that 74% chose SalesAdjustments, 14% chose Sales (the real, true, correct answer), 8% chose Both, and 4% chose Neither. If the latter numbers are correct, shouldn't the summary indicate 14% gave the correct answer and 86% gave the incorrect answer? Is this mismatch due to your fixing the "correct" answer and awarding points back?

Eirikur Eiriksson SSC Guru Points: 182631 More actions · Answer 12

Eirikur Eiriksson

SSC Guru

Points: 182631

September 9, 2014 at 7:59 am

#1744136

sknox (9/9/2014)

This isn't a mistake. It's Steve's subtle way of getting us to write more questions:

http://qa.sqlservercentral.com/articles/SQLServerCentral/115420/

😀

Sure made me question but not necessarily did it urge me to write one:-P

😎

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 13

pmadhavapeddi22

SSCertifiable

Points: 5306

September 9, 2014 at 8:10 am

#1744142

Recently I have used the MERGE statement and answering made it simple.

Steve Jones - SSC Editor SSC Guru Points: 728159 More actions · Answer 14

Steve Jones - SSC Editor

SSC Guru

Points: 728159

September 9, 2014 at 8:49 am

#1744152

Eirikur Eiriksson (9/9/2014)

Sure made me question but not necessarily did it urge me to write one:-P

😎

C'mon, give us a good one. 😛

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 15

Vimal Lohani

SSCommitted

Points: 1650

September 9, 2014 at 9:44 pm

#1744304

Thanks for returning point.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature