columns operation

[pchaitanya]

Hi all,
Is there any way so that I can get data in a column as column headers for that table

[gpl]

It sounds like you are wanting to create a crosstab query (where for each value in a column you return a count) - if thats right, put crosstab into the search box at the top and you will find many posts about it.

If that isnt what you want, just say a little clearer what it is you want to do

[ck9663]

Or search PIVOT or UNPIVOT

-- CK

[pchaitanya]

Thank u,
In case of using pivot we should initially declare the required item or column .
How can we read column dynamically at run time

[ck9663]

You might be able to get away by building your T-SQL dynamically.

-- CK