Currently I'm doing this I just want to check is there any other way its possible. Any how Thanks for you your reply!

I try but its not work

SELECT a.* from @address a

where a.AddressID = 9

FOR XML path('Addresses'), ELEMENTS XSINIL

Thanks!

Thanks its solve my issue

like query is not much simple here I just create simple query to show the issue.

Is there any work around for this or I can create new temp table...