March 29, 2012 at 10:42 am
Hello..I have a table like below:
Patient_id last_name first_name health_plan
1 abc xyz ae
2 abc xyz fs
The values of health_plan can change..
I want to pivot this table to get the following output..
Patient_id last_name first_name health_plan_1 health_plan_2
1 abc xyz ae fs
Can somebody please help me with this pivoting?
Thanks in advance..
March 29, 2012 at 11:42 am
I'd recommend starting with these resources.
March 29, 2012 at 12:37 pm
Chrissy321 (3/29/2012)
I'd recommend starting with these resources.http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/%5B/quote%5D
If you surround the urls with the IFCode shortcut [ url ] and [ /url ] without the spaces inside the brackets, the urls become hotlinks like this:
[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply