Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Sorting working differently after moving from SQL Server 2008 to 2012 RE: Sorting working differently after moving from SQL Server 2008 to 2012

  • October 9, 2015 at 3:55 am

    #1832489

    Assuming the "Please select" needs to be the first entry? then the ORDER BY needs to perhaps be:

    ORDER BY

    CASE WHEN EmpLogin = '-1' THEN 1 ELSE 2 END,

    AttorneyName