Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Declare @repayment_in_yrs numeric(10,2)
- SET @repayment_in_yrs = 1.1
- select ((@repayment_in_yrs % 1)*100)/10
- Select ((@repayment_in_yrs - (@repayment_in_yrs %1)) * 12)
- Select (((@repayment_in_yrs % 1)*100)/10) + ((@repayment_in_yrs - (@repayment_in_yrs %1)) * 12)
Add Comment
Please, Sign In to add comment