hi!all,

I hv resource data as below

(format to month-year)
resourcetype resourcedate resourceload
R001 jan-03 2
R002 feb-03 1
R003 mar-03 4
R004 jan-03 5

when ever I create a cross tab query I get a wrong order for the months and
year.
I want format as below example --

resourcetype jan-03 feb-03 mar-03 totalload
R001 2 2
R002 1 1
R003 4 4
R004 5 5

but always feb-03 comes before march why ?
Please advice !!!

Regards
jit



MS Sql Server LazyDBA home page