<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Jason Selburg
»
Data Driven Subscriptions
40 posts, Page 3 of 4
««
«
1
2
3
4
»»
Data Driven Subscriptions
Rate Topic
Display Mode
Topic Options
Author
Message
i_amhers
i_amhers
Posted Friday, October 17, 2008 2:16 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, October 26, 2012 1:10 PM
Points: 4,
Visits: 31
You should save Jason some time by scrolling up
2 posts
.
If, however, you are unable to scroll here is the link:
http://www.sqlservercentral.com/articles/Development/2824/
-Thanks again Jason for the original post
Jeremy
Post #587988
DeafEater
DeafEater
Posted Thursday, June 18, 2009 2:59 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:15 AM
Points: 123,
Visits: 227
Jason your post on manipulating SSRS subscriptions says you've incorporated various of the suggestions made by other contributors and a later post of yours suggests that the amended version is now posted with the article. However as far as I can see, the code in the article is still the original so is the amended version with variable numbers of parameters available from anywhere else?
Thanks for sharing as I was beginning to think it was just me that wanted to do this sort of thing. We need to email suppliers with a nicely formatted PDF of unacknowledged purchase order lines and your solution will be perfect for iterating through the list of affected suppliers and ensuring each one is notified with only the PO lines associated with them.
Regards
Robert Cowan
Post #737290
Jason Selburg
Jason Selburg
Posted Thursday, June 18, 2009 10:09 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:55 AM
Points: 2,582,
Visits: 3,552
All,
This is a link to the most recent version. I have not returned to work on this process since it's creation and there may be many ways to improve upon it.
I submit this solution for you to build upon and improve at your leasure.
Enjoy!
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given
HERE
you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Post #737728
DeafEater
DeafEater
Posted Thursday, June 18, 2009 10:35 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:15 AM
Points: 123,
Visits: 227
Thanks Jason.
The improvement I've started on is rather than use pipe delimited placeholders in the various ExtensionSettings and Parameter values is to convert those two XML fields into table variables (two fields called 'Name' and 'Value'). Then it becomes much easier to update the values of such 'Name' keys as already exist and inserting the ones that don't. Then I can convert the two table variables back to XML and update the ExtensionSettings and Parameters fields with the respective values.
The idea behind doing it this way is that the stored subscription record can be a perfectly valid one that will run without alteration if needs be and the caller of the stored procedure can keep as many default values as it wants and supply only the amended or additional ones.
If it works out OK I'll post it as another variation on a theme.
Regards
Robert Cowan
Post #737761
jdubious
jdubious
Posted Wednesday, October 21, 2009 5:12 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:04 PM
Points: 6,
Visits: 173
Has anyone has success using this (excellent) sproc and sending to a group? We have 1 report, 1 parameter (userid), and several users getting the same report queried for their userid. The users receiving the report changes constantly. I'm trying to use a cursor (which prints out the result set correctly) to retrieve userid and email but the reports don't send. No errors and the job indicates that is has run once for each record in the query set. If I run the sproc for a single userid, it works fine, so email, job, etc are configured correctly. Any suggestions?
J.
*****
DECLARE curRevcon INSENSITIVE CURSOR
FOR SELECT CONTACTID, EMAIL FROM Table
DECLARE @CONTACTID VarChar(100)
DECLARE @EMAIL VarChar(100)
OPEN curRevcon
FETCH NEXT FROM curRevcon INTO @CONTACTID, @EMAIL
WHILE @@Fetch_Status = 0
BEGIN
EXEC data_driven_subscription
@scheduleID = '317F5B31-B453-4037-B85A-42907A9956A4',
@emailTO = @EMAIL,
@emailCC = '',
@emailBCC = '',
@emailReplyTO = 'me@me.com',
@emailBODY = 'Testing - did you get this?',
@param1 = @CONTACTID
FETCH NEXT FROM curRevcon INTO @CONTACTID, @EMAIL
END
CLOSE curRevcon
DEALLOCATE curRevcon
GO
Post #806880
Prince Ali
Prince Ali
Posted Monday, November 02, 2009 9:34 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, December 11, 2012 12:48 PM
Points: 37,
Visits: 399
Thanks for the great proc.
Post #812447
george.greiner
george.greiner
Posted Tuesday, April 06, 2010 10:13 AM
Valued Member
Group: General Forum Members
Last Login: Yesterday @ 10:21 AM
Points: 69,
Visits: 174
Does this also give me the ability to process a batch subscription. For instance if there are 10 finished files within the last 24 hours that need to go out in 10 separate reports (1 report per record) in 10 separate emails will this get the job done?
Post #897686
Jason Selburg
Jason Selburg
Posted Tuesday, April 06, 2010 11:08 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:55 AM
Points: 2,582,
Visits: 3,552
george.greiner (4/6/2010)
Does this also give me the ability to process a batch subscription. For instance if there are 10 finished files within the last 24 hours that need to go out in 10 separate reports (1 report per record) in 10 separate emails will this get the job done?
Sure. Wrap the call to this procedure in another procedure that loops through the list of reports that need to go out.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given
HERE
you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Post #897737
george.greiner
george.greiner
Posted Tuesday, April 06, 2010 11:11 AM
Valued Member
Group: General Forum Members
Last Login: Yesterday @ 10:21 AM
Points: 69,
Visits: 174
Jason Selburg (4/6/2010)
george.greiner (4/6/2010)
Does this also give me the ability to process a batch subscription. For instance if there are 10 finished files within the last 24 hours that need to go out in 10 separate reports (1 report per record) in 10 separate emails will this get the job done?
Sure. Wrap the call to this procedure in another procedure that loops through the list of reports that need to go out.
Okay cool I will attempt this today. I am new to SSRS and am doing what I can to do this and am glad this will be the way to get this done! Thanks for the quick reply and good work!
Post #897742
whuili
whuili
Posted Wednesday, April 28, 2010 4:15 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, April 28, 2010 4:10 PM
Points: 1,
Visits: 1
There is an app that does data-driven subscriptions for SQL Server Standard 2005 here: http://www.imageteq.com/Support/IMAGETEQSolutions/tabid/112/Default.aspx
Post #912414
« Prev Topic
|
Next Topic »
40 posts, Page 3 of 4
««
«
1
2
3
4
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
