WITH t1 AS
(
SELECT
A.TaskID,
coursename= (
STUFF(
(SELECT ',' + OwnerAccount
FROM BPMDB.dbo.BPMInstProcSteps b
WHERE A.TaskID= b.TaskID AND b.OwnerAccount IS NOT NULL AND DATEDIFF(YEAR,b.FinishAt,GETDATE())=0
FOR xml path('')
),1,1,''
)
)
FROM BPMDB.dbo.BPMInstProcSteps A WHERE a.OwnerAccount IS NOT NULL AND DATEDIFF(YEAR,A.FinishAt,GETDATE())=0
GROUP by A.TaskID
)