I wouldn't think a general query would work out for you. I would suggest
you to look at some other tool that can do cross tab reporting easily &
efficiently (like Excel Pivot tables) rather than T-SQL.

Hope this helps,
John

-----Original Message-----
From: Singh Jitender [mailto:jitender.[Email Address Removed]
Sent: Tuesday, August 19, 2003 1: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