I have a query that gives the amount of wages for a given member of the employee
Select Overall * Neutroprave staff staff = = staffref
from the total cost as a staff bauerate however, if the value returned is> 105, then I would like to add an extra bit of math need to. To do so, if the value is & lt; 105 is returned as value, although if value is> 105 then I need to value * 1.128.
For example:
John Smith's cost is 90; Therefore, the cost of David Smith is 140 so the query is 157.92
should come back I'm sure there is some way to use it to use it, but I only want
Try to do something like that.
Select TotalCost = Case (Totalhors * StaffbaseAet) & lt; 105 THEN (Total Staffestate) ELSE (Total House * StaffBoAreate) * 1.128 Android from Nutrotra, where stafff = @steff
Comments
Post a Comment