Cross Tab Data

[Lost User]

Hi experts I am using SQL Server 2005 I have Table Having Str. like __________________________ Heading | Tax __________________________ A | Taxx A | Taxz A | TAXN B | 10 B | 20 B |30 C |5 C |5 C |4 _____________________________ i Want Result like -------------------------------- A B C ---------------------------------- TaxX 10 5 TaxZ 20 5 TaxN 30 4 -------------------------------- The No's of Column also dynamic i.e A B C D .... so on then help but Query in Using to get this Result Dinesh

[Jerry Hammond]

I believe you're looking for something like the following:

USE AdventureWorks
GO
SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS Emp4, [233] AS Emp5
FROM
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) AS p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( [164], [198], [223], [231], [233] )
) AS pvt
ORDER BY VendorID;

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

[Mycroft Holmes]

This may help Pivot article[^]

Never underestimate the power of human stupidity RAH