Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
Untitled
a guest
Jan 18th, 2019
88
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
text
0.19 KB
| None
|
0
0
raw
download
clone
embed
print
report
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)
Add Comment
Please,
Sign In
to add comment
Public Pastes
🤑 G2A.com Free Gift Card Guide Apr 2024 FIX 🤑
GetText | 28 min ago | 0.39 KB
util.lua
Lua | 29 min ago | 2.15 KB
3x4.lua
Lua | 31 min ago | 0.53 KB
Untitled
FreeBasic | 1 hour ago | 0.29 KB
2024-04-25_stats.json
JSON | 2 hours ago | 3.61 KB
2024-04-25_stats.json
JSON | 2 hours ago | 3.60 KB
2024-04-25_stats.json
JSON | 2 hours ago | 3.57 KB
Weight Method - CS220
Java | 3 hours ago | 3.66 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!