title: Stored procedure with named parameter and calculation
body: <p>I'm calling a stored procedure with named parameter. </p>
  
  <pre><code>exec MySP @name = 'binesh', @amount = @amt, @date = @date
  </code></pre>
  
  <p>It's working fine for me.</p>
  
  <p>But when I'm trying </p>
  
  <pre><code>exec MySP2 @name = 'binesh', @amount = -@amt, @date = @date
  </code></pre>
  
  <p>or </p>
  
  <pre><code>exec MySP3 @name = 'binesh', @amount = @amt, @date = convert(varchar(25), @date, 131)
  </code></pre>
  
  <p>I get a syntax error.</p>
  
  <p>Is this mandatory that I need to create separate variables for each (common sense tells it won't be the way). So what is the syntax for this?</p>
  
  <p>Thanks all</p>
  
  <p>Binesh</p>