/*Write a stored procedure named “spAddPercentage” that adds a percentage (passed as a
parameter named “In
cPercent”) to the value of an order if the value of IncPercent is under
10%, or if IncPercent is 10% or over, add 10% to the value of an order for all orders in the
OrderDetails table utilising IF/ELSE.*/


Use SKILLAGEITDB
go
Create procedure [spAddPercentage]
as
declare @incPercent decimal(1,0)
if @incpercent < 0.1


 update OrderDetails
 set value = value * 1.10
 begin


 if @incpercent = 0.1
 update OrderDetails

 set value = value * (1 + @incpercent)
 else


 end