Post reply

UNION Query help

  • October 18, 2013 at 8:22 am

    #1659734

    T.Ashish (10/17/2013)

    Jeff Moden (10/17/2013)

    ScottPletcher (10/17/2013)

    Or just:

    ORDER BY 1

    I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

    change a lot 🙂 :

    Thank goodness that method has finally been deprecated.

    +1 for Jeff Moden

    Why? Just makes it more difficult to order complex columns and/or UNIONed statements.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

  • October 18, 2013 at 9:25 am

    #1659765

    ScottPletcher (10/18/2013)

    T.Ashish (10/17/2013)

    Jeff Moden (10/17/2013)

    ScottPletcher (10/17/2013)

    Or just:

    ORDER BY 1

    I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

    change a lot 🙂 :

    Thank goodness that method has finally been deprecated.

    +1 for Jeff Moden

    Why? Just makes it more difficult to order complex columns and/or UNIONed statements.

    Is as simple as using column aliases from first query.:-)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 20, 2013 at 12:49 am

    #1659949

    Luis Cazares (10/18/2013)

    ScottPletcher (10/18/2013)

    T.Ashish (10/17/2013)

    Jeff Moden (10/17/2013)

    ScottPletcher (10/17/2013)

    Or just:

    ORDER BY 1

    I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

    change a lot 🙂 :

    Thank goodness that method has finally been deprecated.

    +1 for Jeff Moden

    Why? Just makes it more difficult to order complex columns and/or UNIONed statements.

    Is as simple as using column aliases from first query.:-)

    Even I have never used ordinal position ever, so I'm glad its deprecated.

Viewing 3 posts - 16 through 17 (of 17 total)

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