Forums - C# Corner

Forum guidelines
darma teja

darma teja

  • 518
  • 238
  • 148.3k

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 Hyderabad Developer Conference

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.