T-SQL to concatenate multiple rows of DateTime column
Problem I need to concatenate the following EventDate (latest to oldest) into a single row grouped by ParentWebGuid on Microsoft SQL 2008 R2 database view: SELECT TOP ( 100 ) PERCENT ParentWebGuid , TypeOfEvent , CONVERT ( VARCHAR ( 10 ) , EventDate , 103 ) AS EventDateString FROM dbo . SupervisionEvent WHERE ( TypeOfEvent = 'Visit [P]RP' ) ORDER BY ParentWebGuid , EventDate DESC Solution SELECT DISTINCT TOP ( 100 ) PERCENT ParentWebGuid , REPLACE ( ( SELECT TOP ( 100 ) PERCENT CONVERT ( VARCHAR ( 10 ) , EventDate , 103 ) AS 'data()' FROM dbo . SupervisionEvent WHERE ( TypeOfEvent = 'Visit [P]RP' ) AND ( ParentWebGuid = mainTable . ParentWebGuid ) ORDER BY EventDate DESC FOR XML PATH ( '' ) ) , ' ' , ', ' ) AS VisitPrpEventDates FROM dbo . SupervisionEvent AS mainTable WHERE ( TypeOfEvent = 'Visit [P]RP' ) Explanation AS 'data()...