a guest Jan 18th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT SUM(CAST(yourcolumn AS DECIMAL(10, 2)))
- FROM yourtable
- select sum(cast(qty as DECIMAL(10, 2)))
- from inventory i
- where i.refDocNum = 485
- and i.refApp = 'WO'
- and i.type in (20, 21)
RAW Paste Data