hi,
I have a table like this,
pin subcode avg_marks
1 301 20
1 302 19
1 303 18
1 304 09
1 305 15
1 306 12
1 307 18
1 308 20
1 309 17
1 310 16
1 311 11
Now I want to have table as
pin 301 302 303 304 305 306 307 308 309 310 311
1 20 19 18 09 15 12 18 20 17 16 11
i tried to do this using pivot table. I can't do it. I am using sql server 2000.