multiple columns in one row

[nagarjunamukara]

hey hi i have table like this
a b c
1 4 7
2 5 8
3 6 9

i need that all data under a,b,c in once column of another name like this
d
1
2
3
4
5
6
7
8
9


is there any possibility to get solution means please please reply to my mail...

[ariful alam]

try self union to show the columns in one column

[ck9663]

Option 1:
Unpivot your data

Option 2
Use UNION ALL

Option 3
1. Concatenate your columns
2. Try doing this...

Happy Coding!!!


~~ CK

[nbiswas]

Declare @t table(a int,b int,c int)

Insert Into @t select 1,4,7 union all select 2,5,8 union all select 3,6,9

select d = a from @t union 
select b from @t union 
select c from @t

~~CK: How will you fit your first (Unpivot) and last Option (Concatenate your columns) in this case? Curious to know about this with working code

[ck9663]

It might actually the longest way to do it but it will still work...

Here, try running this:

with x 
as
(
   select 1 as a, 4 as b, 7 as c
   union all 
   select 2, 5, 8
   union all
   select 3, 6, 9
) 
select 
   d
from   
 (
   select a, b, c
   from x
 ) p
 UNPIVOT
   (
     d for columnname in (a,b,c)
   ) un

The last option will work in similar manner. I can post a sample code if you want, but it could be later :)

Happy Coding!!!


~~ CK

[vickysatya]

select c1 from #ta union select c2 from #ta union select c3 from #ta