I am using a stored proc in SQL server 2005
My proc is recieving an XMLTyped stream using the schema http://www.w3.org/2001/XMLSchema
. (The same schema used in Datatable.writeXML). In the proc I want to dynamically create a hash table having the column names and data in the XML transfered into the hash table.
I need this to be a generic process so I can't code any mapping as different column names and indeed a different number of columns could be received in the XML. I have looked for code examples on the net of how to do this but currently with no luck
P.S. In preference I would prefer to use a table var as the stucture of the table has to be able to change I don't think this is possible
Many thanks for your help