Home Forums SQL Server 2012 SQL Server 2012 - T-SQL display order by houseno RE: display order by houseno

  • December 18, 2013 at 2:06 am

    #1674309

    twin.devil (12/16/2013)

    ChrisM@home (12/15/2013)

    Each one of your five current threads

    select quarie between houseno ..........

    select house_no order

    select only up to first '-' only

    display order by like 1,2,3,4,5...............plz write quarie

    display order by houseno

    relate to the same issue. Help us and you will help yourself. Please provide a sample data set which is properly representative of your data. Your data doesn't all look like "3-9-55". If it did, any one of several solutions already posted would work just fine.

    Is "3-9-55" just a Hyderabad house number or is it three data elements combined into one?

    :w00t: now these are some threads ....

    501's, mate. Best in the world 😛

    “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