Vertical to Horizontal 1

[mayamanako]

hi guys, can you please give me an idea how i can convert the table below:

name   col1  col2  col3
fruits  111   222   333
veg     444   555   666

and to have a recordset that's something like this?

name   col1  col2  col3  vegname  vegcol1  col2  col3
fruits  111   222   333     veg     444     555   666

thanks for any help.

 

[sabinUE]

Hi,

A question: always have those rows (2 rows)?
depending of this , below it's a sample code

;with yourTbl as
(select 'fruits' as [name],  111 as col1,  222 as col2,   333 as col3 union all
 select 'veg',     444,   555  , 666 )


 select F.name as fruitName,F.col1 as fruitCol1,F.col2 as fruitCol2,F.col3 as fruitCol3, 
	V.name as vegName,V.col1 as vegcol1,V.col2 as vegcol2,v.col3 as vegcol3
 from 
 (select name,col1,col2,col3
  from yourTbl
  where name='fruits') as F
  cross join
  (
  select name,col1,col2,col3
  from yourTbl
  where name='veg'
  ) as V

Ce-am pe mine am si-n dulap, cand ma-mbrac zici ca ma mut
sabin

 

[mayamanako]

Hi sabinUE,

That's awesome! This is exactly what I needed. Thanks v much!

 

[sabinUE]

with welcome
glad to help



Ce-am pe mine am si-n dulap, cand ma-mbrac zici ca ma mut
sabin