Hi Everyone,

Thanks for help. Actually I tried for it little bit differently and it seems that its working fine. New query is as follows for reference.

SELECT A.WebRefNum, L.LVDesc [Legal...

Many thanks for reply.

For your information I'm working on SQL Server 2000 and I think there is no ON DELETE SET NULL. Could you please help me in this...

Thanks for suggestion.... Is their any way to save that xml output in a file automatically? I mean can we write a script for that to send output of that...

Is it possible to save xml output of query, directly to file ?? If anyone knows please help.