The XML I have shown is a sample file that I have to create.

I dont have the t-sql code. I need T-SQL to generate such file.

How ever, I am attaching...