Forums - C# Corner

Forum guidelines
darma teja

darma teja

  • 956
  • 406
  • 156k

sql query for getting 4 colums data into one column

Feb 15 2013 10:06 AM
Hi,

I tried allot on this qury but I am not succeeded.
My problem is:

I have 4 columns in my table:

example:

col1        col2        col3        col4
xxx            1          11           111
xxx             5          55           555
yyy           2          22          222
zzz            3          33          333
zzz            4           44         444

my result output should be:

col1          col2
xxx           col2-1; col3 -11; col4-111; col2-5; col3 -55; col4-555;
yyy           col2-2; col2-22; col2-222;
zzz            col2-3; col3 -33; col4-333; col2-4; col3 -44; col4-444;



thanks in advance

Darma










Answers (4)

C# Corner Annual Conference 2017

SPONSORED BY

File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!