|
|
concatenate dynamic rows in sql
Last post 09-23-2009, 8:20 AM by twaligora. 0 replies.
-
 09-23-2009, 8:20 AM |
-
twaligora
-
-
-
Joined on 01-11-2007
-
-
Posts 57
-
-
|
concatenate dynamic rows in sql
declare @Output varchar(1000)
SELECT @Output = COALESCE(@Output+', ', '') + CONVERT(varchar(20), ol.prdnum)
FROM dbo.ord_ln ol
WHERE ordnum = @order
select @Output
|
|
|
|
|