Databases > AdventureWorks2019 > Stored Procedures > uspGetBillOfMaterials

AdventureWorks2019

uspGetBillOfMaterials

//

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

Created: 5/8/2023 Modified: 5/8/2023

Parameters

//

Input parameter for the stored procedure uspGetBillOfMaterials. Enter a valid ProductID from the Production.Product table.

@StartProductID

[int] NULL
//

Input parameter for the stored procedure uspGetBillOfMaterials used to eliminate components not used after that date. Enter a valid date.

@CheckDate

[datetime] NULL

Definition