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
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