Convert multiple rows to one record or variable 1

[Z1]

I have a varible table with one column and multiple row. I want one row with the combination of all rows. Below is the example:
E01
E02
E03
Output : E01,E02,E03

 

[gmmastros]

Declare @Temp Table(Data VarChar(10))

Insert Into @Temp Values('E01')
Insert Into @Temp Values('E02')
Insert Into @Temp Values('E03')

Declare @Output VarChar(1000)

Select 	@Output = Coalesce(@Output + ',', '') + Data
From	@Temp

Select @Output

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Z1]

Thanks George for your help. You have my star for this week.

 

[gmmastros]

Glad to help.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[rafrancisco]

Hi Z1,

You may also look into the following link (which is basically the same process that George answered):

http://www.sql-server-helper.com/tips/comma-delimited-output.aspx

 

[Z1]

Thanks rafrancisco,

I was using as follows to get my desired result as your web site indicates:
DECLARE @CustomerIDs VARCHAR(8000)
SELECT @CustomerIDs = ISNULL(@CustomerIDs + ',', '') + [CustomerID]
FROM [dbo].[Customers]
ORDER BY [CustomerID]
PRint @CustomerIDs

BUT I have trouble after I add ORDER clause. The above deletes all the records and keep the last record only in the variable. This works perfect in the table where there is no fill factor. I have fill factor 80 for the index in my table (which I am using) and the result is incomplte.
Example:
ID Error
1 E21
1 E12
1 E03
Result with above code : 1 E03
As soon as I remove "Order by" clause the result comes correct(1 E21,E12,E03) . Any idea?

Z1