Forums - C# Corner

Forum guidelines
darma teja

darma teja

  • 946
  • 376
  • 152.4k

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)

Visual Studio Live - Redmond 2016

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.