имеем:

select(select @month as [month] ,
@day as [day],
@year as [year]
for xml raw ('date')
)for xml path ('listing')

получаем :
<listing><date month="11" day="22" year="2008"/></listing>

почему не?:
<listing><date month="11" day="22" year="2008"/></listing>

получаем :
<listing> & l t ; date month="11" day="22" year="2008"/ & g t ; </listing>

почему не?:
<listing><date month="11" day="22" year="2008"/></listing>[/quot]