asked
Converting rows into columns
Hi I have a table Code Colour Desc ---------------------- D Blue ABC E1 Green DEF L Red GHI I Yellow JKL I want the result like the this: Code1 Colour1 Desc1 Code2 Colour2 Desc2 Code3 Colour3 Desc3 Code4 Colour4 Desc4 ------------------------------------------------------------------------------- D Blue ABC E1 Green DEF L Red GHI I Yellow JKL
DECLARE @Horizontal varchar(max) select @Horizontal = coalesce(@Horizontal + ' ',' ') + code1 + ' '+ color1 + ' '+ desc1 from color select @Horizontal
15 People are following this question.
