A minor improvement is to use the stuff function s...

2011-10-14T14:52:33.413-04:00

A minor improvement is to use the stuff function so you are not limitted to 1000 characters. This will stuff a empty string info the first two characters.

Stuff(
(select '; ' + ipc.PostalRegion
from #tmpPostalCode ipc
inner join #tmpCustomerAddress ica
on ipc.PostalCode = ica.PostalCode
where
ica.CustomerId = ca.CustomerId
and ica.StateAbbreviation = ca.StateAbbreviation
for xml path('')), 1, 2, '')

Comments on RDA BI/SQL Server Practice Group Blog: Using FOR XML PATH to Combine Multiple Record Valu...

A minor improvement is to use the stuff function s...