Results 1 to 1 of 1
Thread: MSSQL money field rounding
Dec 20, 2004, 09:03 #1
MSSQL money field rounding
This is really annoying I have a money field that SQL Server keeps rounding so if I enter 17.99 it turns it into 18 when I retrive the value from the DB I get 18.000 back. Im relatively new to MSSQL and my beginner book is on the way.....whats the deal?
I've also tried the field as a decimal with the same result.
All right I've found the problem was in my insert stored procedure i had left it as a decimal thats now fixed. Now I need help with the trailing zeroes. They're not stored in the DB is this something I should parse out in my app or that I can fix in my retrieval stored procedure.