Heh, seems I've been unable to describe the structure without actually writing it out :-). Here are the create scripts for the tables (the actual ones have a bit more...

Thanks, Phill!

That article was indeed interesting, but it didn't quite solve my problem. What I'm effectively trying to do is to with one insert statement insert data into...

Hi Brendon

Even though you are programming in Java I dare say that an excellent resource for all things pertaining to the xml dom and sql server is the Microsoft Developer...