Union results

Question

Union results

Jason Whitish

SSChasing Mays

Points: 642
More actions
September 21, 2011 at 8:23 pm

#245246

Comments posted to this topic are about the item Union results
September 22, 2011 at 1:40 am

This was removed by the editor as SPAM

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks for the question.

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

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 2

Iulian -207023

SSCertifiable

Points: 7639

September 22, 2011 at 12:33 am

#1384953

Thank you for the question,

Regards,

Iulian

Carlo Romagnano SSC-Insane Points: 22596 More actions · Answer 3

Carlo Romagnano

SSC-Insane

Points: 22596

September 22, 2011 at 1:21 am

#1384963

Very simple. Thanks. 🙂

M&M SSC-Insane Points: 21700 More actions · Answer 4

M&M

SSC-Insane

Points: 21700

September 22, 2011 at 2:06 am

#1384977

Good question, thanks.

M&M

Thomas Abraham SSChampion Points: 10761 More actions · Answer 5

Nice example of the question not being more complicated than necessary to demonstrate the point. Thanks for the question.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Stuart Davies SSCoach Points: 19505 More actions · Answer 6

Good questions - thanks

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 7

thanks for the question!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 8

Good straight forward question. Thanks for posting it.

http://brittcluff.blogspot.com/

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 9

Ha! My reasoning was right, but apparently I need some more caffeine so I can count. 🙂

Tony++ SSCarpal Tunnel Points: 4421 More actions · Answer 10

Lost the point but learned something new.

I knew that union deduped the sets, but I never thought it through to the logical conclusion that it dedups all rows in all sets. Makes sense though.

Thanks for stretching my brain this morning.

sknox SSChampion Points: 12388 More actions · Answer 11

Tony++ (9/22/2011)
Lost the point but learned something new.
I knew that union deduped the sets, but I never thought it through to the logical conclusion that it dedups all rows in all sets. Makes sense though.
Thanks for stretching my brain this morning.

Well, technically it doesn't dedupe all rows in all sets. It dedupes all of the rows in the output. It essentially performs a DISTINCT operation on the final intermediate data set.

Cliff Jones SSChampion Points: 10547 More actions · Answer 12

Daniel Bowlin (9/22/2011)
Ha! My reasoning was right, but apparently I need some more caffeine so I can count. 🙂

Yes, I saw 1,2,3 and almost forgot to count the null value. Good straight forward question with all the likely wrong answers.

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 13

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

September 22, 2011 at 8:47 am

#1385212

Thanks - Nice easy question to kick of the day.