Как получить значение атрибута в запросе FOR XML EXPLICIT?

Question

[Виталий]

Как получить значение атрибута name в узле param в запросе?

запрос SQL:

SELECT TOP (1)
	1 as Tag
	,0 as Parent
	,NULL as [offers!1!]
	,[P].[Id] as [offer!2!id]
	,NULL as [offer!2!name!ELEMENT]
	,NULL as [offer!2!description!CDATA]
	,NULL as [offer!2!param!ELEMENT]
	FROM [dbo].[Product] as [P]
	UNION ALL
SELECT TOP (1) 
	2 as Tag
    ,1 as Parent
    ,NULL
    ,[P].[Id]
	,[P].[ShortDescription]
	,[P].[MetaDescription]
	,N'белый' as [param]
FROM [dbo].[Product] as [P]
FOR XML EXPLICIT

получаю XML:

<offers>
  <offer id="1">
    <name>Пост</name>
    <description><![CDATA[Набор]]></description>
    <param>белый</param>
  </offer>
</offers>

нужно получить XML:

<offers>
  <offer id="1">
    <name>Пост</name>
    <description><![CDATA[Набор]]></description>
    <param name="Цвет">белый</param>
  </offer>
</offers>