Using this query:
With cte(answer, computer) as (select 42, 'Deep Thought') select answer as '@answer', computer from cte for xml path('Question')
<Question answer="42"><computer>Deep Thought</computer></Question>
but I want:
<Question answer="42">Deep Thought</Question>
How should I change my query to get that?