title: Arithmetic overflow error converting money to data type numeric
body: <p>This is my query I am inserting  a values in the in the temp table, but I am getting the error like this..</p>
  
  <blockquote>
    <p>Arithmetic overflow error converting
    money to data type numeric.</p>
  </blockquote>
  
  <p>Query is:</p>
  
  <pre><code>DECLARE @EBT money
  Declare @ConversionRatio money
  Declare @TotalRevenues money
  
  insert into #SummarySheet(Item,INR,Dollar,Percentage) 
  VALUES ('EBT', isnull(@EBT,0), isnull(@EBT,0)/isnull(@ConversionRatio,0), 
           isnull(@EBT,0)/isnull(@TotalRevenues,0))
  
  FYR:
  </code></pre>
  
  <p>The values are:</p>
  
  <pre><code>@TotalRevenues="1.00"
  @EBT="-50995944.26"
  @ConversionRatio="44.5"
  </code></pre>
  
  <p>How to rectify it....</p>