Know Your Data

• rscarlson

  SSC Eights!

  Points: 856

  More actions

  March 24, 2005 at 3:11 pm

  #362249

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rcarlson/knowyourdata.asp

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  April 4, 2005 at 10:34 am

  #550373

  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 Varsha

• Raja-187848

  SSC Enthusiast

  Points: 154

  More actions

  April 18, 2005 at 5:47 am

  #553112

  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