Generated using SQL Data Dictionary demo version.

Procedure dbo.uspGetBillOfMaterials

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

Parameter Data Type Default Is Output
@StartProductID int
Input parameter for the stored procedure uspGetBillOfMaterials. Enter a valid ProductID from the Production.Product table.
@CheckDate datetime
Input parameter for the stored procedure uspGetBillOfMaterials used to eliminate components not used after that date. Enter a valid date.


Column Data Type Nullable
ProductAssemblyID int X
ComponentID int X
ComponentDesc nvarchar(50) X
TotalQuantity decimal(38,2) X
StandardCost money X
ListPrice money X
BOMLevel smallint X
RecursionLevel int X