/**
*  Test Data
**/
DECLARE	@ParentItem TABLE(ParentID INT IDENTITY(1,1) NOT NULL PRIMARY KEY, ParentName NVARCHAR(50), ParentDate DATETIME);
DECLARE	@ChildItem TABLE(ChildID INT IDENTITY(1,1) NOT NULL PRIMARY KEY, ParentID INT, ChildName NVARCHAR(50));
INSERT @ParentItem(ParentName,ParentDate)
SELECT 'The first one','01 jan 2009' UNION ALL
SELECT 'The second one','01 feb 2009'
INSERT @ChildItem(ParentID,ChildName)
SELECT 1,'Cat' UNION ALL
SELECT 1,'Dog' UNION ALL
SELECT 1,'Monkey' UNION ALL
SELECT 2,'Teapot' UNION ALL
SELECT 2,'Merkin' UNION ALL
SELECT 2,'Grommet'

/**
*  The concatination
**/
SELECT	p.ParentID, p.ParentName,
		STUFF((SELECT ', ' + ChildName FROM @ChildItem WHERE ParentID = p.ParentID FOR XML PATH('')),1,2,'')
FROM	@ParentItem p
GROUP	BY p.ParentID, p.ParentName