asked on
use Dictionary
go
WITH Filtered
AS ( SELECT W.Word, w.WordPosition, w.clientcode, w.ClientCodeWordPosition, w.StrShort
FROM tblwords w
LEFT JOIN tblwordtags wt ON W.clientcodeWordPosition = wt.clientcodeWordPosition
WHERE wt.word IS NULL and w.ClientCodeWordPosition like '95052350%'
)
SELECT o.ClientCodeWordPosition, o.clientcode, o.StrShort,
RTRIM(( SELECT I.Word + ' '
FROM Filtered I
WHERE I.clientcode = O.clientcode
order by i.WordPosition
FOR
XML PATH('')
)) AS ConcatWordText, o.WordPosition
FROM Filtered O
order by o.WordPosition