Posted by Malc on 05/11/06 05:14

See for yourself...

use pubs
go

declare @var varchar(1000)
set @var = ''
select @var = @var + ' ' + pub_id from pub_info
where 1 = 1
order by
pub_id desc
print @var

• Next in forum: how to create a real (not virtual) table from view1 & view2 ni sql server?
• Prev in forum: Re: Need Emergency Advice
• Thread view: Re: Select several values into a single variable

[Reply to this message]