Create a function?

Create a function using SQL that takes as inputs a SalesOrderID, a CurrencyCode, and a date, and returns a table of all the SalesOrderDetail rows for

Create a function using SQL that takes as inputs a SalesOrderID, a CurrencyCode, and a date, and returns a table of all the SalesOrderDetail rows for that Sales Order including Quantity, ProductionID, UnitPrice, and the unit price converted to the target currency based on the end of the day rate for the date provided. (Exchange rates can be found in the Sales.CurencyRate table)

or:Create a function using SQL that takes as inputs a SalesOrderID, a CurrencyCode, and a date, and returns a table of all the SalesOrderDetail rows for that Sales Order including Quantity, ProductionID, UnitPrice, and the unit price converted to the target currency based on the end of the day rate for the date provided. (Exchange rates can be found in the Sales.CurencyRate table)

Tags:table,