MM,

Yes your solution defitnitly works and you are right about not using the OpenXML. I actually intend to insert XML data into a table and then use your query to...

My actuall code is slightly different. The reason I need to use openXML is because I plan to automate this import as the XML content would be part of XML...

Chris,

You are awesome, This works perfect, only thing I had to change was to set the RoomStatus varchar to (max) since some of the Restaurants had like many many rooms....

The query still was being executed over 5 minutes gone by without an error so I stopped it.

Sorry about that Chris, I plugged in my query where you were inserting by selecting UNION ALL, and it seems to work find when i execute it with some keys...

Chris,

Really apperciate your help, Sorry forgot to mention Since I will have close to 500 Restaurants, I will not be able to hardcode each value. Would you know of...