Glad you stayed awake long enough to give me my answer though! Is there a way to give you points on this? I don't see anywhere to do...

THANK YOU!! Works great! So instead of using a 'UNION ALL', just create two separate 'SELECTS' with the same 'AS'. Awesome, thanks again!

This should be the complete query:

SELECT

c.ID,

c.CaseName,

-- <Mappings>

'boolean' AS "Mappings/@AutoCleanup",

'boolean' AS "Mappings/@PreserveExistingRecords",

(

SELECT

u.Uses AS "@Name",

'Category' AS "@EntityType",

'uniqueidentifier' AS "@GUID"

FROM

Uses u

INNER JOIN...

I hope this is correct...here is the data:

INSERT INTO Cases (CaseName)VALUES('My Case')

INSERT INTO Uses (Uses)VALUES('Military Cases')

INSERT INTO Uses (Uses)VALUES('Footlocker Cases')

INSERT INTO CaseToUses (CaseID, UsesID)VALUES(1,1)

INSERT INTO CaseToUses (CaseID, UsesID)VALUES(1,2)

INSERT INTO CaseToComputer...

Here's scripts to create the tables. I am working on the data insert.

/****** Object: Table [dbo].[Cases] Script Date: 08/20/2008 13:29:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET...

How do you use a UNION ALL with XML PATH?

I have two queries I need to pull together to get create my child nodes for and I am...