We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Agreed on the poor design but fixing is another issue. Thanks for the quick reply. You've certainly given my more motivation to change the design....

I've got a table that is used to capture the results of various user actions to products as they flow through a system. Sample data for the table would look like the following Item] [Action] [ActionDateTime] Widget1 Welded 2012-12-12 12:34:01...

Below is a simplified query that returns the records for a single engine (serializedpartid='14549') I'd like to modify it to return all engines in the Engines table, creating an engine node for each engine and single fleet parent node. Replacing 'seri...

Below is a simplified query that returns the records for a single engine (serializedpartid='14549') I'd like to modify it to return all engines in the Engines table, creating an engine node for each engine and single fleet parent node. Replacing 'seriali...

Never mind on the last question. I figured it out. I really appreciate the help!...

Great! and one last question. Got both options functioning and have expanded the XML Path option to include several other nodes beneath part to add details from other tables. Using the XML path solution can I create a Location node at the same level a...

Hope you can make sense of the above, not sure what I did to get the xml to display like that. Thanks....

**Serialized Parts Table (NextHigherSN is a foreign key back SN in the same table)** PartId,SN,NextHigherSN,LCF 1,448999,448999,34 2,ABC123,448999,45 3,DEF5456,448999,67 4,XXX123,DEF5456,22 5,448333,448333,23 6,GFR345,448333,45 7...

I have created a CTE (PartTree) that returns a list of indentured parts in an engine. Its very similar in concept to the often cited example of retrieving manager/subordinates from an employees table. //Recursive CTE Select [Part].SerialNumber, [Par...