select query with rows into columns.

[kingstonr]

Hi,

I am having my query result like below.

ID PID Pname Class
----------------------------
1 P1 Pname Class1
1 P1 Pname Class2
1 P1 Pname Class3

Now I want that three rows into one row like below

ID PID Pname Class1 Class2 Class3
------------------------------------------
1 P1 Pname Class1 Class2 Class3

can somebody help me out in this.


Thx
kingston

 

[RiverGuy]

Take a look at the PIVOT operator:

http://blogs.msdn.com/craigfr/archive/2007/07/03/the-pivot-operator.aspx

However, when possible, I believe it best to do this on the front end reporting tool.