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 -------------------------------- this Result in Datagrid view in WinForms How i get it in Datagrid view my column A,B,C ,D ..... so on Dynmaic Dinesh

[Baran M]

Pivots[^]

Education is not a way to escape poverty — it is a way of fighting it.

[Mycroft Holmes]

You don't even have to leave CP [^] to get a solution

Never underestimate the power of human stupidity RAH