Gsquared,

Just wanted to thank you for all the help. Everything is working like a charm!

One related question I thought you might have an opinion on:

Instead of using Identity columns a...

I guess since we have other relational databases I just assumed that was the way to go. Once the data is stored in the DB it will be queried for...

GSquared,

Awesome! Works great!

I assume I just have to add three more sections similar to the UUTProperty section to get my other tables populated.

Thanks for all your help. After your initial...

I think the only error in logic was my fault. You must not have seen my last post. I mistakenly sent you a DB script without the name field being...

GSquared,

I just realized I forgot to take the name field out of the UUTproperty, UUTMeasurement, UUTPassFailTest and UUTStringCompTest equivalent database tables. The name is now in the UUTDataElement node. Maybe...

GSquared,

Attached is a script to create the tables and sample xml that has data to populate each table. The trouble I'm having is with the UUTDataElements parent node and UUTproperty,...

Thanks GSquared,

I'll look at the OUTPUT clause but what I really need help with is how do I iterate through each UUTDataElement node (like a for...each). If I can do...