When you define a column in MS SQL server as either decimal or numeric (these are both options but do the same thing) you need to define a fixed precision and scale value for that column.

I've tried this on SQL Server 2000 and SQL Server 2005 and I can't seem to figure it out...If I declare a decimal(38, 20) it doesn't give me 20 decimal places. declare @d1 decimal(38, 20) declare ...