|
visakh16
Very Important crosS Applying yaK Herder
India
47069 Posts |
 Posted - 11/15/2012 : 05:27:55
|
[code]
SELECT Col2 AS [T],[a1],[b1]
FROM (SELECT Col2,Col3,Col4
FROM Table
WHERE Col1 = @YourValue
)t
PIVOT (MAX(Col4) FOR Col3 IN ([a1],[b1]))p
[code]
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
How to query this complex query, rows to columns?
