Home Forums SQL Server 2008 SQL Server Newbies ORDER BY non-sequential number sequence RE: ORDER BY non-sequential number sequence

  • January 13, 2013 at 1:39 am

    #1576669

    select x.NewSid, sid

    from tbl_xenix

    CROSS APPLY (SELECT NewSid = ('S'+CAST ([statusId] AS VARCHAR(255)))) x

    order by CHARINDEX(x.NewSid,'S5S4')

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]