how can i get the results in column format

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

how can i get the results in column format

Author

Topic

satish.gorijala
Posting Yak Master

182 Posts

Posted - 2009-06-03 : 05:39:13

Hi, How can i get the results in column format(i.e vertical)

Ex: EmpNo Empname
12 user1
45 user5
56 user6

The result i want as

EmpNo 12 45 56
Empname user1 user5 user6

G. Satish

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-03 : 05:46:02

Concatenated or pivoted?

E 12°55'05.63"
N 56°04'39.26"

satish.gorijala
Posting Yak Master

182 Posts

Posted - 2009-06-03 : 05:51:34

No concatenation.. i think its pivot

quote:
Originally posted by Peso

Concatenated or pivoted?

E 12°55'05.63"
N 56°04'39.26"

G. Satish

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-03 : 05:52:38

If it is concatenated


declare @t table(EmpNo int, Empname varchar(10))
declare @empno varchar(8000), @empname varchar(8000)
insert into @t
select 12, 'user1' union all
select 45, 'user5' union all
select 56, 'user6' 

select 
	@empno=coalesce(@empno+' ','')+cast(empno as  varchar(10)),
	@empname=coalesce(@empname+' ','')+empname
from
	@t
select 'Empno' ,@empno
union all
select 'Emp name',@empname