How can we write the columns set as rows set?

With Out Using The Temporary tables(# tables).

You can try that using case statment.

[QUOTE=debasisdas;29187]You can try that using case statment.[/QUOTE]


If we know the columns set then only we can use the case statement, if did not know the column set then what is the way to get?

If you want to do it dynamically better to use Procedure for that .

Hi all i am new to this forum ...