David,

Yes you're right it was the drop statement that didn't work. Many thanks for your two suggestions. I pasted in the first one and everyting works  beautifully.

Frank,

Yes, a very good point....

Thomas,

Many thanks for your advice. It works! I've written the T-SQL below that writes out all...