Clever Geek Handbook

Select from table then form whitespace separated string in stored procedure

I want to highlight about 4-5 rows from a table and then form a space separated row.

All of this must be done in a stored procedure (SQL Server 2005).

Is it possible?

Then I will use this separator string and store it in another table.

Update

SELECT *
FROM Users
WHERE userID < 10

output:

john
jake
blah
sam

So, put this on a space separated line:

'john jake blah sam'

and store this row in another row in the table.

All of this should be done in a stored procedure (if possible).

+1


source to share


2 answers 


DECLARE @firstnames varchar(max)

SELECT 
    @firstnames = COALESCE(@firstnames + ' ', '') + FirstName 
FROM 
    Users 
WHERE 
    UserId < 10

INSERT INTO OtherTable (OtherColumn) VALUES (@firstNames)


+3


source


I think something like this will work:



DECLARE @whatever varchar(max)  -- or varchar(1000) or whatever size
SET @whatever = ''

SELECT @whatever = @whatever + MyColumn + ' ' FROM MyTable
0


source






More articles:


All Articles