Posted by Pacific Fox on 01/09/08 01:39

You're a champ!

I got it to work with your code, with one slight modification, see
final code below.

SELECT 1 AS tag
, NULL AS parent
, NULL AS [GoogleCustomizations!1]
, NULL AS [Annotations!2]
, NULL AS [Annotation!3]
, NULL AS [Annotation!3!about]
, NULL AS [Annotation!3!score]
, NULL AS [Annotation!3!Label!element]
, NULL AS [Label!4!Name]
UNION ALL
SELECT 2 AS tag
, 1 AS parent
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
UNION ALL
SELECT 3 AS tag
, 2 AS parent
, NULL
, NULL
, NULL
, domainName
, 1 -- score
, NULL
, NULL
FROM domainName
UNION ALL
SELECT 4 AS tag
, 3 AS parent
, NULL
, NULL
, NULL
, domainName
, 1 -- score
, NULL
, '_cse_ad-o6lgdody'
FROM domainName
ORDER BY [Annotation!3!about], tag
FOR XML EXPLICIT

Thanks a million! Anything I can help with in return?

• Next in forum: Selecting SUM and COUNT, but not straightforward..
• Prev in forum: Re: FOR XML EXPLICIT can't get element 4 going
• Thread view: Re: FOR XML EXPLICIT can't get element 4 going

[Reply to this message]