|
|
|
SSC Rookie
 
Group: General Forum Members
Last Login: Friday, November 07, 2008 7:59 AM
Points: 28,
Visits: 3
|
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Thursday, November 05, 2009 12:49 PM
Points: 3,425,
Visits: 493
|
|
Totally agree. Just had a similar task. I used multiplying by 1.00 and then used Convert to make the output look nice for the report Convert(decimal(7,3),Orders*1.00/mytotal) Yelena
Regards,
Yelena Varshal
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 04, 2006 11:03 PM
Points: 2,
Visits: 1
|
|
Article provides good insight. I found this issue while I was trying to write a big stored procedure to run complex calcualtions. I did not know the adding or subtracting .0 technique  . I created temporary variables of decimal type and reassigned values to these variables and used them in my calculation. But adding .0 would have been far more simpler and efficient. Raja
|
|
|
|
|
SSC-Addicted
Group: General Forum Members
Last Login: Saturday, November 21, 2009 1:33 PM
Points: 476,
Visits: 294
|
|
Needs to add information about the problems with the proprietary MONEY and BIT data types. Needs to learn to use CAST() and not CONVERT() when coding.
|
|
|
|
