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
>
MS Sql Server LazyDBA home page