With Out Using The Temporary tables(# tables).
You can try that using case statment.
Originally Posted by debasisdas You can try that using case statment. 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 ...
Forum Rules