SELECT DISTINCT empcode, STUFF( ( SELECT distinct ',' + Cast(Day([Date]) AS varchar) FROM dcr p1 WHERE p.empcode= p1.empcode FOR XML PATH(''), TYPE ) --.value('.', 'NVARCHAR(MAX)') ,1,1,'') as DateConcate FROM dcr p;
Msg 8116, Level 16, State 1, Line 1<br /> Argument data type xml is invalid for argument 1 of stuff function.
SELECT DISTINCT empcode, STUFF(( SELECT distinct ',' + Cast(Day([Date]) AS varchar(20)) FROM dcr p1 WHERE p.empcode= p1.empcode FOR XML PATH('')),1,1,'') as DateConcate FROM dcr p;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)