CommaDelmitedList2.sql

Use AdventureWorks

-- fill up temp table 1 ( [Schema], [Event] )
SELECT DISTINCT [Schema], [Event]
INTO    #tempTbl1
FROM    DatabaseLog 
ORDER BY [Schema], [Event]

-- create delimited list
SELECT  [Schema],
        Events = STUFF( 
        (
            SELECT   ',' + [Event]
            FROM     #tempTbl1 mp2
            WHERE    mp2.[Schema] = mp1.[Schema]
            FOR XML PATH('')
        ), 1, 1, '' )
FROM    #tempTbl1 mp1
GROUP BY mp1.[Schema]