Question: Create a function that accepts a quantity, unit price and tax rate. The function should first calculate the total value of the information passed in
Create a function that accepts a quantity, unit price and tax rate. The function should first calculate the total value of the information passed in - (quantity * unit price) * 1+taxrate. If there are more than 100 items purchased, give a discount of 8%. If more than 250 item were purchased, give a 12% discount Return the final value. Use the Sales.OrderLines records to test your function. As outlined earlier in class, name your function with your first initial and full last name (dbo.rreed_CalculateDiscount) */
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
