Databases > AdventureWorks2019 > Scalar Functions > ufnGetProductDealerPrice

AdventureWorks2019

ufnGetProductDealerPrice

//

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

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

Parameters

//

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

returns

[money] NULL
//

Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid ProductID from the Production.Product table.

@ProductID

[int] NULL
//

Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid order date.

@OrderDate

[datetime] NULL

Definition