Databases > AdventureWorks2019 > Stored Procedures > uspGetWhereUsedProductID

AdventureWorks2019

uspGetWhereUsedProductID

//

Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.

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

Parameters

//

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

@StartProductID

[int] NULL
//

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

@CheckDate

[datetime] NULL

Definition