help me plz.

[ghousal]

i have a query i.e
"select ename from emp"
am getting result as
ename
aaa
bbb
ccc
ddd
ok
means i want to get these values 1 beside 1 like
aaa bbb ccc ddd etc
plz help me out

[CyberSoftHari]

Explain your problem in detail.

[jamesd0142]

Explain your problem in detail.

I think this is explained well enough...

Basically all retrieved values in the same row rather than a row for each value

[CyberSoftHari]

Did he mean cross tab query?

You have to use storeprocedure.

[Jim Doherty]

i have a query i.e
"select ename from emp"
am getting result as
ename
aaa
bbb
ccc
ddd
ok
means i want to get these values 1 beside 1 like
aaa bbb ccc ddd etc
plz help me out

Here is a stored procedure that will return you your single row separating the values with one space (you can amend that obviously to suit you)

 
CREATE PROCEDURE dbo.usp_MySP
AS
DECLARE @a varchar(8000)
SELECT @a=COALESCE(@a, '') + ename + space(1) FROM (SELECT distinct (ename) from emp) as a
SELECT rtrim(ltrim(@a)) AS [MyValues]
GO

Regards

Jim :)