How can I display filed name as a column, can any body help...
There is one table name School and it contain 4 records and in the future
might be it will increase but I want to display that records as a column
like this
1.............. First School
2.............. Second School
3...............Third School
4................Fourth School
now I want like this
First School Second School Third School
Fourth School
45 99 0
0
99 22 1
0
Thanks
Jens Süßmeyer - 06 Jul 2005 10:40 GMT
That´s a crosstab thing which could be handled with y CASE statement:
http://www.paladn.com/dynamic-crosstabs.htm
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
> How can I display filed name as a column, can any body help...
>
[quoted text clipped - 17 lines]
>
> Thanks