SQL Data Types problem

Question

Hi Friends I have two fileds in sql server. 1.tran_amt numeric(160) 2.amout numeric(122) I have select the amount column and update to the tran_amount column. My problem is tran_amount should be came roundable value. But I want exact value(with points) ex: amout=1467.95 update A set tran_amount=@amout Result : 1468 Expected Result : 1467.95 Please help me on this...

sukumar s · Answer

Hi burak seyhan  Thanks a lot.

sukumar s · Answer

Hi Vulpes  Thanks a lot.

burak seyhan · Answer

I think if you use C# languges first rounded data on C# then send SQL that's the best solution

sukumar s · Answer

Hi Money.

burak seyhan · Answer

Did you try money or decimal data type ?

Vulpes · Answer

That's not going to be possible unless you can change the type of tran_amount to (16 2) so that it can accommodate 2 decimal places.