Home Forums SQL Server 7,2000 T-SQL Order by clause RE: Order by clause

  • December 15, 2008 at 2:17 am

    #912337

    rbarryyoung (12/14/2008)

    Hmm, I think that we must have interpreted his post differently, Chris.

    Heh - yeah, think so. I didn't read it properly first time. "1" first, followed by everything else including "0", in an unspecified sorted order.

    Sanjay, can you list these items in the order in which you wish them to appear?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden