Hi Jacob,

Thanks a lot for your prompt response. The only problem is I am not a .Net developer and only do database development and administration. One thing that I do want to mention is that performance is not one of the top priority for this process as it will be used to load data into destination tables maybe once/twice a month on demand depending upon if the user needs to change the variable values after the intial load. This will be actually used to load configuration values into our configuration database and has two columns and atmost maybe about hundred rows in the two destination tables with minimum growth overtime.

Yes your are right, I have been trying to play around with the XML data type methods in SQL 2008 and find that it has few limitations on how much I can do, hence wanted to get your advice if it is at all possible to do just with XML data type methods in SQL 2008 and maybe T-SQL wherever needed.

I did look at some .Net libraries including LINQ and see that it has more coverage on handling such task.

But I have no choice at this time to do it using .Net as it will take some time to learn even the basics and I need to complete this task by next week. I will discuss with my team regarding the limitation that I may have doing this in SQL, but it seems I will have it get around it using SQL as the .Net developers in the team are busy with other tasks.

Thank you so much for your feedback. I really appreciate that. Atleast I know from you that it is not impossible using XML data type in SQL through your experience.