Exporting Summary of money data to .CSV file using DTS

• kumar-200106

  Newbie

  Points: 1

  More actions

  July 14, 2006 at 4:41 pm

  #68330

  Hi Folks .

  I have been strugling in getting the two decimal values(It is rounding to Numaric Value with no Decimals) in the .CSV file after I have done with DTS by Summing up all the Money values of Money data field from a Table..I did not have problem in getting decimals exporting to .CSV file.

  This is example

  1. Select Sum(Money) from Moneytable 

      in QUERY Analyzer i am getting like this ..989988.92

     after exporing to .CSV file i am getting it as  ..989989 (Problem)

   

  1. Select Money from Moneytable 

      in QUERY Analyzer i am getting like this ..82.92

     after exporing to .CSV file i am getting it as  ..82.92  (No Problem)

   

  Can any body has solution please let me know

  Thanks.

• Peter Schott

  SSCrazy Eights

  Points: 9675

  More actions

  July 15, 2006 at 4:05 pm

  #649420

  Can you CAST(SUM(Money) as numeric(12,2)) or something similar?

  -Pete