TSQL problem

[habneh]

declare @name varchar(1000)
set @name = ''

1 select @name = @name + convert(varchar(1000),id)+ ', '
from tbl

2 select @name

How can I combile statement 1 and 2 so that I can do it in a single statement

select (select @name = @name + convert(varchar(1000),id)+ ', '
from tbl)

gives me an error

Thanks

 

[monksnake]

I didn't think it was possible, and I came across this site.

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=176

<.

 

[monksnake]

The example page is not the EXACT same problem as what you have, but it does state that you can not retrieve any data from a select that also assigns a value to a varaible, so even putting the assigning select into a subquery won't fix the problem.

<.

 

[habneh]

Thanks monksnake