Union results

  • Jason Whitish

    SSChasing Mays

    Points: 642

    Comments posted to this topic are about the item Union results

  • SQLRNNR

    SSC Guru

    Points: 281243

    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: 7509

    Thank you for the question,

    Regards,

    Iulian

  • Carlo Romagnano

    SSC-Insane

    Points: 21987

    Very simple. Thanks. 🙂

  • This was removed by the editor as SPAM

  • M&M

    SSC-Insane

    Points: 21699

    Good question, thanks.

    M&M

  • Thomas Abraham

    SSChampion

    Points: 10761

    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: 18878

    Good questions - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere 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

    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

    Good straight forward question. Thanks for posting it.

    http://brittcluff.blogspot.com/

  • Daniel Bowlin

    SSC-Dedicated

    Points: 34566

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

  • Tony++

    SSCarpal Tunnel

    Points: 4311

    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: 12292

    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: 10517

    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

    Hall of Fame

    Points: 3994

    Thanks - Nice easy question to kick of the day.

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

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