Merge Targets

Question

Post reply

Merge Targets

Viewing 15 posts - 31 through 45 (of 46 total)

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

Maciej Łuszczyński SSC Enthusiast Points: 171 More actions · Answer 1

92% of wrong answers so far 😉 I think something went wrong with the today's Question of the Day edition.

sknox SSChampion Points: 12388 More actions · Answer 2

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

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

😀

Steve Jones - SSC Editor SSC Guru Points: 736524 More actions · Answer 3

Andy_J (9/9/2014)
😀 Who else thinks Steve should lose 1000 points for that one?

LOL, probably should. Apparently I can't figure out which box to check.

Steve Jones - SSC Editor SSC Guru Points: 736524 More actions · Answer 4

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.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 5

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: 281334 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: 2935 More actions · Answer 7

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: 281334 More actions · Answer 8

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: 281334 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: 281334 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://www.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: 2582 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: 182917 More actions · Answer 12

sknox (9/9/2014)
This isn't a mistake. It's Steve's subtle way of getting us to write more questions:
http://www.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

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

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

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. 😛

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 15

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