DECLARE @ItemDesc VARCHAR(MAX) select A.EmpName,(SELECT @ItemDesc = COALESCE(@ItemDesc +',' ,'') + ItemDesc FROM Items where Items.Itemid = B.Itemid) as ItemDesc from Emp A inner join Orders B On A.EmpId = B.EmpId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)