T-SQL 2005: One-to-many comma separated

We have 2 tables one-to-many. How can we fetch parent table field, and the second field is its children comma separated ? In MSSQL 2000 we could use the following function. But in MSSQL 2005 with the help of FOR XML PATH feature it is a lot easier and the performance of string concatenation is amazing.

SELECT CustomerID
      ,(SELECT CAST(OrderID AS VARCHAR(MAX)) + ',' AS [text()]
          FROM dbo.Orders AS O
         WHERE O.CustomerID = C.CustomerID
         ORDER BY OrderID
           FOR XML PATH('')) AS Orders
  FROM dbo.Customers AS C;

Related Posts:

• Oracle: development tool needed
• MSSql 2005: XML indexes and XML queries
• MSSQL 2005: XQuery Implementation in RDBMS
• Primary Key best practices: INT identity vs. UniqueIdentifier (GUID)
• How to change column datatype in Oracle table (ALTER TABLE).
• The DBA Guide to the SQL Server Database Engine .NET CLR (whitepaper)
• MSSQL 2000: Service Pack 4
• MSSQL 2005: BACKUP LOG changes
• MSSQL: The value of Default Constraint
• MSSQL 2000: Row Count Using sysindexes System Table