Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CASE WHEN isnull(emp_pay_type,0) = 0 then '$' +
- (CASE WHEN isnull(convert(MONEY,emp_pay_rate),0) > 300
- THEN convert(varchar,convert(money,isnull(emp_pay_rate,0)*isnull(emp_work_hours,1)*52),1)
- ELSE convert(varchar,isnull(convert(MONEY,emp_pay_rate)*26,0)) END)
- ELSE '$' + convert(varchar,isnull(convert(MONEY,emp_pay_rate)*26,0)) END
Add Comment
Please, Sign In to add comment