Thanks J-F.

I think this approach can solve my problem listed earlier.

But I have come across another problem. When I try excuting following query on PUB database its showing me only half output. I can't see all rows converted to xml. M I misssing anything?

Query-:

SELECT store.stor_id as Id, stor_name as Name, sale.ord_num as OrderNo,

sale.qty as Qty

FROM stores store inner join sales sale on store.stor_id = sale.stor_id

ORDER BY stor_name

FOR XML AUTO

Output-:

<sale Ord

I think editor will not show xml output I pasted under output.

Could you please suggest here.