April 13, 2007 at 12:35 am
Hi All,
I have a result set like say a client with more than one inservice date.
And i am grouping those inservices for a particular client.
say i get some 4 or 5 inservice date for it.
i have some 10 columns in my group head and in detail i want to display this inservice date not in rows to be transposed to columns and if this inservice exceeds the 10 columns it should move to next row
is that possible?
sample:
clientname cert 1 date 1 cert 2 date 2 cert 3 date 3
__________________________________________________________________
Abey 1 1/2/2005 2 1/3/2005 3 1/5/2005 inserdate1
inserdate2
inserdate3
inserdate4
inserdate5
inserdate6
inserdate7
inserdate8
inserdate9
__________________________________________________________________
Aboaf 1 1/2/2005 2 1/3/2005 3 1/5/2005 inserdate1 inserdate2 inserdate3 inserdate4 inserdate5 inserdate6 inserdate7
__________________________________________________________________
and i should get like this
clientname cert 1 date 1 cert 2 date 2 cert 3 date 3
Abey 1 1/2/2005 2 1/3/2005 3 1/5/2005 inserdate1 inserdate2 inserdate3 inserdate4 inserdate5 inserdate6 inserdate7
inserdate8 inserdate9
__________________________________________________________________
Aboaf 1 1/2/2005 2 1/3/2005 3 1/5/2005 inserdate1 inserdate2 inserdate3 inserdate4 inserdate5 inserdate6 inserdate7
please help me!
Regards
Priya
April 13, 2007 at 5:21 pm
Without more detail on your reordset, If your using SQL 2005 then look into the PIVOT function.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply