How to add data from table to string

Question

Have table @tbl with INT data :

want select this id-s and set to declare @myStr nvarchar(max) with " | " It must be like : 1|2|3|4|5| how to do it ?

possible duplicate of [Concat groups in SQL Server](http://stackoverflow.com/questions/941103/concat-groups-in-sql-server) — Clockwork-Muse, May 01 '14 at 11:28

score 1 · Accepted Answer · answered May 01 '14 at 08:55

1

Use following Query:

declare @myStr nvarchar(max)

set @myStr=(SELECT STUFF((
SELECT '|' + CONVERT(VARCHAR,ID)
FROM @tbl
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, ''))

SELECT @myStr

answered May 01 '14 at 08:55

Chandresh Koyani

362
1
6

How to add data from table to string

1 Answers1