Thanks Steve

Actually, my table is in the following form.

Assets NULLNULL

Current Assests NULLNULL

Cash and cash...

I am trying to copy data from table to xml format using following command.

DBCC traceon(257)

select feidl1,feidl2,feild3 from table FOR XML AUTO, ELEMENTS

following is the output which I am getting from...