title: Can you use "Drop table ......." in SSRS
body: <p>I am creating a report which drops the table if it exists at the beginning and inserts the data that is needed.</p>
  
  <p>The SQl runs smoothly in SQL Server Management Studio with no issues but when I place it into SSRS to create a report, it is saying that the synax is wrong.</p>
  
  <p>I think I might need to do this as a stored procedure but I wanted to make sure that I have not missed anything first.</p>
  
  <p>Thanks in advance.</p>