bryan.holmstrom (7/30/2015)

---

This code sends an error: I must have something coded wrong?

Msg 156, Level 15, State 1, Line 11

Incorrect syntax near the keyword 'FROM'.

WITH CTE_Concat AS

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT '; ' + lb.ListName

FROM ReznickGroup_MSCRM.dbo.ListMemberBase lmb

INNER JOIN ReznickGroup_MSCRM.dbo.ListBase lb ON lb.listid = lmb.listid

WHERE lmb.entityid = cb.contactid

FOR XML PATH('')),1,1,'') AS ConcatValues

FROM ReznickGroup_MSCRM.dbo.ContactBase cb