SSC Eights,

Great response.

Do you mind elaborating more on the:

FOR XML PATH(''),TYPE

).value('.','VARCHAR(MAX)') , 1,1,SPACE(0)) AS Concat_Values

string of your solution...

Hi,

It has to do with how SQL manages defaults.

For UNION queries, DISTINCT is the default. So if you really want to preserve duplicates you'll have to explicitly put ALL, but...

Hello,

I have been using http://www.sql-ex.ru/.

Great site. Full of excersises with varying difficulty.

Joe,

I 'll buy your book. Thanks for your note.

And, I strongly disagree asking Joe for the scripts...