@mark-3

Great, works a treat, many thanks as this was my first attempt at shredding a complex XML struxture.

Regarding the above script,

If I wanted to redirect the output to another server, how would I change the script security wise, i.e. how would the logon/security be changed via...

Thanks, gave that a quick try and it seems to work OK, I'll try changing the path now to get it to write to another server.

Thanks for that but I'm getting an error when I try to run it

Server: Msg 170, Level 15, State 1, Procedure usp_ExportXML, Line 28

Line 28: Incorrect syntax near 'queryout'.