title: Data Driven Subscriptions SSRS Standard Edition 2008
body: <p>I'm fairly new to MSSQL and SSRS.</p>
  
  <p>I'm trying to create a data driven subscription in MSSQL 2008 Standard SSRS that does the following.</p>
  
  <p>Email the results of the report to a email address found within the report.
  Run Daily</p>
  
  <p>For Example:</p>
  
  <pre><code>Select full_name, email_address from users where (full_name = 'Mark Price')
  </code></pre>
  
  <p>This would use the email_address column to figure out who to email, This must also work for multiple results with multiple email address's.</p>
  
  <p>The way I'm thinking of doing this is making a subscription to run the query, if no result is found then nothing happens.
  But if a result is found then the report changes the row in Subscriptions table to run the report again in the next minute or so with the correct email information found in the results.
  Is this a silly idea or not?</p>
  
  <p>I've found a couple blog posts claiming this works but i couldn't understand their code enough to know what it does.</p>
  
  <p>So, Any suggestions on how to go about this or if you can suggest something already out there on the internet with a brief description?</p>