Your solution works pretty good. Simpler as well.

Just one question. Does this syntax work with older versions of SQL Server as all our clients won't be having SQL Server 2014?

Thanks...

I will have a stored procedure that will read the xml file and populate data in a couple of tables for further processing. This sp will be called from the...

Thanks so much.

Why doesn't Openxml work in this case?

//Hari