I have seen in anothe post how this can be done but SQL Server 2005 does ot support GROUP_CONCAT.

 

Can someone convert this into code that is compatible?

 

SELECT     res.resourcename 'Resources',
GROUP_CONCAT(attach.RESOURCENAME SEPARATOR '\n') 'Attached Asset',
GROUP_CONCAT(COMPONENTNAME SEPARATOR '\n') 'Component'
FROM         REsources res LEFT JOIN
                      ResourceAssociation resa ON res.resourceid = resa.ASSTTORESOURCEID LEFT JOIN
                      Resources attach ON resa.RESOURCEID = attach.RESOURCEID LEFT JOIN
                      ComponentDefinition cd ON attach.COMPONENTID = cd.COMPONENTID
GROUP BY 1
ORDER BY 1

 

Many thanks

Dave