title: Using function as a parameter when executing a stored procedure?
body: <p>I'm testing a stored procedure and wanted to submit 'GETDATE()' function in place of parameter:</p>
  
  <pre><code>DECLARE @return_value int
  
  EXEC @return_value = my_stored_procedure
          @MyId = 1,
          @MyDateField = GETDATE()
  
  SELECT  'Return Value' = @return_value
  GO
  </code></pre>
  
  <p>SQL Server 2005 complains with following error:</p>
  
  <blockquote>
    <p>Incorrect syntax near ')'.</p>
  </blockquote>
  
  <p>Anybody care to shed some light on the matter?</p>