sarwaanmca (12/28/2012)

I am already tried following Method..

select * from xmldata FOR XML AUTO

select * from xmldata FOR XML AUTO, ELEMENTS

SELECT * FROM xmldata FOR XML PATH('Root')

select * from xmldata FOR XML RAW('Node')

But still i Didn't get Exact File Structure...

(Above Mentioned File Structure The Parent / Child hierarchy Should be Must)

Any One Try this...ASAP...

Thanks & Regards,

Saravanan.D