title: sql query return value issue
body: <p>i am multipying the values in the query</p>
  
  <pre><code>DECLARE  @Rate
  DECLARE @numeric
  DECLARE @Result decimal
  SET  @Rate= .01
  SET  @Result=34750*@Rate
  print @Result
  </code></pre>
  
  <p>but it always displays the value as <strong>0</strong></p>
  
  <p>as per my logic the result should be   <strong>347.5</strong> </p>
  
  <p>after i get the result 347.5 i need  to spilt the values  an d insert into 2 variables
  like </p>
  
  <pre><code>@var1= 347
  @var2=5
  </code></pre>
  
  <p>what wromg i am  doing here please let me know, any help would be great</p>
  
  <p>Thanks
  Prince</p>