Adding Variaables To Subject Line

  • Has anyone found a way to add variables from a report into a subscription's subject line or message body in SQl 2005?  I would like to place a start and end date from the report's stored procedure variables into the subscription's email.

  • http://www.sqlservercentral.com/columnists/jselburg/2824.asp

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • This is good stuff!  I've just started digesting this as well as your other post referencing data driven subscriptions.

    I just can't wait to do some damage with this!

    Thanks!

    -r

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply