Databases > AdventureWorks2019 > Scalar Functions > ufnGetProductListPrice

AdventureWorks2019

ufnGetProductListPrice

//

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

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

Parameters

//

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

returns

[money] NULL
//

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

@ProductID

[int] NULL
//

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

@OrderDate

[datetime] NULL

Definition