RE: Get summary of column values from a result set

One Orange Chip

Points: 26944

April 2, 2013 at 3:14 am

You can do this instead, although I don't think it will make much difference

WITH Results AS (

SELECT CustomerName, PostalCode

FROM @CustomerOffices

WHERE OfficeId BETWEEN @FromOfficeId AND @ToOfficeId)

SELECT 'Summary' as Summary,

STUFF((SELECT ',' + CustomerName AS "text()"

FROM Results

GROUP BY CustomerName

ORDER BY CustomerName

FOR XML PATH(''),TYPE).value('.','VARCHAR(MAX)'),1,1,'') AS CustomerNumbers,

STUFF((SELECT ',' + PostalCode AS "text()"

FROM Results

GROUP BY PostalCode

ORDER BY PostalCode

FOR XML PATH(''),TYPE).value('.','VARCHAR(MAX)'),1,1,'') AS PostalCodes;

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum