Answered You can hire a professional tutor to get the answer.
ALTER PROC spTriangular @ValueIn int, @ValueOut int OUTPUT AS DECLARE @InWorking int; DECLARE @OutWorking int; IF @ValueIn gt; 32 BEGIN THROW 50001,...
I need help with these questions and am using SQL with the adventurework2012 database.
1. Reimplement the spTriangular function from Chapter 12 as a function instead of as a stored procedure. (Query is attached)
2. Create a function that takes as inputs a SalesOrderID, a CurrencyCode, and a date, and returnsa table of all the SalesOrderDetail rows for that Sales Order including Quantity, ProductID,UnitPrice, and the unit price converted to the target currency based on the end of day rate forthe date provided. Exchange rates can be found in the Sales.CurrencyRate table
