Eirikur Eiriksson - Wednesday, May 23, 2018 12:42 AM

Simple syntax error in the value function
😎

This should work

SELECT
  d.[currType]
 ,STUFF(
    (SELECT
      '; ' + d.currName
     from [foo].[dbo].[zool] d
     where f.[issuenum] = d.[issuenum]
     and f.[slipnum] = d.[slipnum]
     and f.[comicsName] = d.[comicsName]
     FOR XML PATH(''), TYPE).value('(./text())[1]','NVARCHAR(2000)'),1,1,'') AS [currNames]
FROM [foo].[dbo].tbl] f
LEFT outer join [foo].[dbo].[Zool] d
on f.[billNo] = d.[billNo];