asked on
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
Microsoft SQL Server
Last Comment
Vitor Montalvão
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.
ASKER
Vitor sir i used it but it shows error so please how to use it can u explain
Can you post your actual query and the error returned?
ASKER
vitor sir above i designed the expected result ,that result query i need can u write the code
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.
ASKER
Table structure and data are given in file. Please find attachment
Query.sql
Query.sql
You query returns error:
Msg 207, Level 16, State 1, Line 73
Invalid column name 'Insuranceprovider'.
Msg 207, Level 16, State 1, Line 74
Invalid column name 'Insurancetype'.
Msg 207, Level 16, State 1, Line 73
Invalid column name 'Insuranceprovider'.
Msg 207, Level 16, State 1, Line 74
Invalid column name 'Insurancetype'.
ASKER
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.