Union results

  • Comments posted to this topic are about the item Union results

  • 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

  • Thank you for the question,

    Regards,

    Iulian

  • Very simple. Thanks. 🙂

  • This was removed by the editor as SPAM

  • Good question, thanks.

    M&M

  • 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

  • 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

  • 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!
  • Good straight forward question. Thanks for posting it.

    http://brittcluff.blogspot.com/

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

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

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

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

  • Thanks - Nice easy question to kick of the day.

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

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