Generated using SQL Data Dictionary demo version.

Procedure dbo.uspGetWhereUsedProductID

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

Parameter Data Type Default Is Output
@StartProductID int
Input parameter for the stored procedure uspGetWhereUsedProductID. Enter a valid ProductID from the Production.Product table.
@CheckDate datetime
Input parameter for the stored procedure uspGetWhereUsedProductID 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