Sorting data in columns

  • I have a table with 4 columns, 3 columns with dates and a column with a count. What I would like to do is sort the dates in a row low to high. For example 10/04/16. 10/02/2016. 10/06/16 would be sorted 10/02/16 10/04/16 10/06/16 in the same row. I thought about doing it with a case statement but is there an easier way? Thanks

  • Duplicate post. Please continue the discussion here.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Viewing 2 posts - 1 through 1 (of 1 total)

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