Table as follows
JSKID Tickets
8765 Bobcat
1001 Bobcat
1001 Confined Spaces
1001 Road
Turn this table to following
JSKID Tickets
1001 Bobcat,Confined Spaces,Road
8765 Bobcat
Select tk1.[JSKID], stuff((SELECT ',' + [Tickets] FROM [tblTickets] tk where tk.[JSKID]= tk1.[JSKID] FOR XML PATH('')),1,2,'' ) AS Tickets from [tblTickets] tk1 group by tk1.[JSKID]
