I have a sql Server 2005 database. My web app has captured a series of answers from the user in xml format. I am passing this xml to a stored procedure and wish to extract the data into tables, but I'm struggling a bit with OpenXML to get the nested data out. I know how to pull out individual tag values, but I need to insert the data sets into these tables:
I have included a schema and the xml data file.
I would appreciate some hlep on this, i don't mind re-structuring the xml file if need be.