you can use datepart(month,resourcepart) to order by but don't display it. If you need help post the query text you're currently using and I can then post the modification.

Brian Freeman
Bluwave Computing/Carnegie Technologies
www.bluewave-computing.com / www.carnegie.com
(770) 916-0595 ext. 415


-----Original Message-----
From: Daniel Klemm [mailto:[Email Address Removed] Tuesday, August 19, 2003 6:21 AM
To: LazyDBA.com Discussion
Subject: Re: Urgent(cross tab query)!!


How is the data being presented to the user?

Can you not convert using some vb/java functions like MonthName() etc.

Daniel



----- Original Message -----
From: "Singh Jitender" <jitender.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Tuesday, August 19, 2003 11:06 AM
Subject: RE: Urgent(cross tab query)!!


> Thanx christine,
>
> But my this resourcetype column is dynamic today is jan-03-mar-03 but
every
> month
> It will grow and can reach to jan-05 also.
>
> Please advice.
> Jit
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page