Views | SQL 2005 Adventure Works OLTP |
BOM_cte used in procedure: dbo.uspGetWhereUsedProductID
Common table expression
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. |
ProductAssemblyID | |
ComponentID | |
ComponentDesc | |
PerAssemblyQty | |
StandardCost | |
ListPrice | |
BOMLevel | |
RecursionLevel | |
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. |
dbo.uspGetWhereUsedProductID | Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. |
Views | Table expressions