Functions | SQL 2005 Adventure Works OLTP |
Scalar function returning the dealer price for a given product on a particular order date.
Syntax
dbo.ufnGetProductDealerPrice ( ProductID, OrderDate )
Parameters
Variable Data Type Required Description ProductID int Yes Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid ProductID from the Production.Product table. OrderDate datetime Yes Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid order date.
Properties
Output data type Transactional Uses cursors Executes procedures Dynamic content Encrypted money No No No No No
Data Source Activity
Accesses Description Production.Product Products sold or used in the manfacturing of sold products. Production.ProductListPriceHistory Changes in the list price of a product over time.
Applies to
Functions | Scalar