|
KlausEngel
Yak Posting Veteran
81 Posts |
 Posted - 11/05/2010 : 21:33:33
|
Try something like this:
SELECT
STUFF((SELECT s2.C1A + ' ' + s2.C1B + ' ' + s2.C1C + ' ' + s1.C1D FROM TableName AS s2 WHERE s2.C1D = s1.C1D FOR XML PATH('')), 1, 1, '') AS Entries
FROM TableName AS s1
ORDER BY s1.C1D |
 |
|
|
glendcruz
Yak Posting Veteran
Australia
60 Posts |
Posted - 11/07/2010 : 01:16:42
|
DECLARE @T TABLE
(
CIA INT,
CIB VARCHAR(10),
CIC INT,
CID VARCHAR(10)
)
INSERT INTO @T
SELECT 001, 'abc', 456, 'test' UNION ALL
SELECT 001, 'abc', 456, 'test1' UNION ALL
SELECT 001, 'abc', 456, 'test2' UNION ALL
SELECT 001, 'abc', 456, 'test3'
select distinct '00'+ cast(j.cia as char(3))as 'cia',j.cib,j.cic ,
STUFF((SELECT TOP 100 PERCENT ' ' + s2.cid
FROM @T AS s2
WHERE s2.cia = j.cia
ORDER BY '' + s2.cid
FOR XML PATH('')
), 1, 1, '') AS 'All text added'
from @t j
(4 row(s) affected)
cia cib cic All text added
----- ---------- ----------- ---------------------
001 abc 456 test test1 test2 test3
(1 row(s) affected)
|
|
|
SQL help
