Did you look at my delay mechanism for file-delivery subscriptions in this same forum?

Jeff Moden (2/5/2010)

---

David McKinney (2/5/2010)

---

Often I will put a descending sort order on a clustered index, so that when I do a select I generally see the latest rows inserted...

Randy-574768 (11/2/2009)

---

Okay, got it! Instead of worrying about username/password for the extensionsettings, you're just editing a pre-existing subscription. Guess I was working too hard at it! 😛

Thanks for the assistance...

Here's some additional sample code. This is the SQL to execute the stored procedure. You use it from the database where the physical data resides, NOT the ReportServer DB.

USE [DBToRetrieveDataFrom]

--...

Maybe this will help. Here's the SP I have. I took the SP from the aforementioned website and created a new delay mechanism for file share delivery that did seem...

Randy-574768 (11/2/2009)

---

Are you referring to the following: http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html?

This is the one that I cannot open. I imagine its just the one I need, so I was hoping someone...

Are you using the code from http://www.sqlservercentral.com/Forums/FindPost683529.aspx?

Refer to the article at http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html to use more than one parameter.

Actually, nevermind that last post. Assuming you want the date range to be from one day to the next (without regards to any time constraints), you may be better off...

You could change the query to say something along the lines of:

EndDate < DATEADD(d,1,@enddate).

Yep, privileges would definitely cause a problem too, lol. Glad you were able to fix the problem!

I could only suggest that you re-create the initial subscription by hand and schedule it for the past. Then just update the query to use the newly created Subscription and...

I haven't had much more time to work on it late last week, but what I have right now is the same as a couple posts prior, with the exception...

Thanks for the parsename trick. I do recall reading about that (probably on here) quite some time ago. For the amount of IPs that had to be converted using the...

I'll try your latest version and let you know. The previous version actually ran SLOWER than using the original version using a temporary table, believe it or not. Nice touch...