Advertisement
Guest User

Untitled

a guest
Oct 24th, 2014
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. ,CASE
  2. WHEN m.COMPLETED_DT is NULL THEN ''
  3. WHEN m.COMPLETED_DT <= m.SLA_ADJUSTED_DT THEN 'SLA Met'
  4. WHEN m.SLA_ADJUSTED_DT IS NULL THEN 'SLA Met'
  5. ELSE 'SLA Missed' END AS "SLA Desc"
  6.  
  7. SELECT (count(*) * 100 / (select count(*) from testtable)) as YesSLA FROM testtable where SLA='Yes';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement