Horizontal comma seperated numbers... 1

[PLCBeetle]

Hello to all...
I am trying to create a MSSql query that will return a horizontal list of numbers seperated by commas using the code below. I am close but not quite working correctly. Any help will be greatly appreciated. Many thanks


DECLARE @pending varchar(500)
SET @pending = ''(SELECT @pending + eco + ', ' FROM mwo.dbo.eco WHERE engineer = 'John Doe')

Result needed like this: 1235, 23423, 66454, 7786, 234, 9276

 

[bborissov]

DECLARE @pending varchar(500)
SELECT @pending = ISNULL(@pending+','  , '') + eco FROM mwo.dbo.eco WHERE engineer = 'John Doe'
SELECT @pending

Borislav Borissov
VFP9 SP2, SQL Server

 

[PLCBeetle]

The data type of eco in the database = Int
The query produces the following error...

Server: Msg 245, Level 16, State 1, Line 2
Syntax error converting the varchar value ',' to a column of data type int.

 

[djj55]

Use a CAST on the eco column

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[bborissov]

DECLARE @pending varchar(500)
SELECT @pending = ISNULL(@pending+','  , '') + CAST(eco as varchar(20)) FROM mwo.dbo.eco WHERE engineer = 'John Doe'
SELECT @pending

Borislav Borissov
VFP9 SP2, SQL Server