Object type: Common table expression

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
BOM_cte
Production.BillOfMaterials	Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Production.Product	Products sold or used in the manfacturing of sold products.

Output Recordset 

Column	Description
ProductAssemblyID
ComponentID
ComponentDesc
PerAssemblyQty
StandardCost
ListPrice
BOMLevel
RecursionLevel

Data source	Description
BOM_cte
Production.BillOfMaterials	Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Production.Product	Products sold or used in the manfacturing of sold products.

Accessed by 

Name	Description
dbo.uspGetBillOfMaterials	Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.

Applies to

Views | Table expressions

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation