If you are just selecting data from an sql server table and want to output it in XML format, try this:

SELECT

txtname

,txtdob

,nomname

,nomadd

FROM myTable as root

FOR XML AUTO,ELEMENTS

Agree.

Always use the SQL92 syntax. Outer joins weren't standardized before this and can return unusual results. -down to the fact that the WHERE clause is not associative. See BOL.

Are there any NULL ID's in #temp3

If so, you won't get any results.

If this is the case, either add a clause AND ID IS NOT NULL when selecting from...