Home Forums SQL Server 2005 Development Order by date not by alphabatical order but by usual jan - Feb etc required RE: Order by date not by alphabatical order but by usual jan - Feb etc required

  • If I try order by month( startdatetime) then it sorts the data by month.

    The problem here is when the data spans to multiple years then it will sort as follows:

    Jan 2011 450 4000

    Jan 2012 200 3651

    Feb 2011 300 6354

    Feb 2012 400 2654

    I want result set instead as follows:

    Jan 2011 450 4000

    Feb 2011 300 6354

    till Dec 2011 and then

    Jan 2012 200 3651

    Feb 2012 400 2654

    and so on