Decimal Data Type

[eselhassan]

Hello all,

I have a decimal data type in my table that holds financial data. I setup the scale to 2, so it holds the decimal places. SQL for some reason kept rounding up. How do I display the data as is. Example, 125.89 display as 126.00
Should I use 'money' data type rather than the decimal data type?
Any help is greatly appreciated.

 

[JayKusch]

smallmoney or money should be used but there are some pitfalls as I recall. still trying to dig that post up. Will relay once I find it.

Thanks

J. Kusch