Generated using SQL Data Dictionary demo version.


Scalar Function dbo.ufnGetProductDealerPrice


Scalar function returning the dealer price for a given product on a particular order date.


Parameter Data Type Default
@ProductID int
Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid ProductID from the Production.Product table.
@OrderDate datetime
Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid order date.

Result:


Data Type Nullable
money X

Uses: