code_junkie

Conditionally replacing values in SELECT

Nov 13th, 2011
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. SELECT totalhours * staffbaserate AS TotalCost
  2. FROM newrotaRaw
  3. WHERE staffref = @staffref
  4.  
  5. SELECT TotalCost =
  6. CASE
  7. WHEN (totalhours * staffbaserate) < 105 THEN (totalhours * staffbaserate)
  8. ELSE (totalhours * staffbaserate) * 1.128
  9. END
  10. FROM newrotaRaw
  11. WHERE staffref = @staffref
  12.  
  13. SELECT
  14. CASE WHEN totalhours * staffbaserate <= 105 THEN totalhours * staffbaserate
  15. ELSE totalhours * staffbaserate * 1.128 END AS TotalCost
  16. FROM newrotaRaw
  17. WHERE staffref = @staffref
  18.  
  19. SELECT totalhours * staffbaserate * (CASE WHEN (totalhours * staffbaserate) < 105 THEN 1 ELSE 1.128 END) AS TotalCost
  20. FROM newrotaRaw
  21. WHERE staffref = @staffref
Add Comment
Please, Sign In to add comment