Because February comes before March?

> -----Original Message-----
> From: Singh Jitender [SMTP:jitender.[Email Address Removed] Sent: Tuesday, August 19, 2003 9:40 AM
> To: LazyDBA.com Discussion
> Subject: Urgent(cross tab query)!!
>
>
>
> 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