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