sampathsoft
SSC Eights!
Points: 855
More actions
November 19, 2010 at 1:53 am
#74144
How to convert Money data type to Decimal or Double . SQL 2005
Give me sample pls
November 19, 2010 at 2:14 am
#1252907
Amount = money
select SUM(CAST(AMOUNT AS decimal(18,2))) FROM tableName
Koen Verbeeck
SSC Guru
Points: 259015
November 19, 2010 at 2:30 am
#1252912
16 digits before the decimal separator, that sure is a lot of money 🙂
(I guess you have already solved the problem, as the statement that you provided should work)
Need an answer? No, you need a question My blog at https://sqlkover.com. MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply