Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
How convert each row of table to as columns in sql server
hi,
I want convert entire row in table as single column , example is show below
QuteNo || requestNo || cat1 || cat2 || cat3
--------------------------
01 1 a b c
2 1 d e f
3 2 g k l
Expected Result :
heading 01 2 3
requestno 1 1 2
cat1 a d g
cat2 b e k
cat3 c f i
I want convert entire row in table as single column , example is show below
QuteNo || requestNo || cat1 || cat2 || cat3
--------------------------
01 1 a b c
2 1 d e f
3 2 g k l
Expected Result :
heading 01 2 3
requestno 1 1 2
cat1 a d g
cat2 b e k
cat3 c f i
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You'll need to use PIVOT but usually you'll need to know the field values otherwise you'll need to do it dynamically that it's more complex.
If you post your code and the error I'll be happy to show you how and where to change it so it can work.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial