Functions SQL 2005 Adventure Works OLTP

dbo.ufnGetProductDealerPrice

Object type: User defined function

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
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.