title: Using stored procedure in Reporting Services
body: <p>I have stored procedure which runs perfectly. And when I insert it into query designer in MS Reporting Services, Ii have error:</p>
  
  <p>Incorrect syntax near 'GO'.
  Incorrect syntax near 'GO'.
  Incorrect syntax near 'GO'.
  The variable name '@s1a' has already been declared. Variable names must be unique within a query batch or stored procedure.</p>
  
  <p>As I said, procedure runs fine in MS SQL Server 2008.</p>
  
  <p>Parameter isn't declared before.</p>
  
  <p>Is there something that needs to be changed so procedure works in Reporting Services?</p>