Home Forums Article Discussions Article Discussions by Author Discuss content posted by Megan Beebe insert multiple rows into variable RE: insert multiple rows into variable
Hari.Sharma
SSCertifiable
Points: 6904
More actions
July 17, 2008 at 6:27 am
#844319
The Best way to use COALESCE function because its very fast compare to other techniques.
select @Numbers = 0, @Strings = ''
SELECT @Numbers = COALESCE(@Numbers,'')+iNumber,
@Strings = COALESCE(@Strings+',','')+sNumber
FROM @demo