Anyone have any ideas on this or have come across a similar issue?

Haven't used a configuration file for the child package actually. With the child package not working either, I'm thinking it may have something to do with that package instead. Problem...

Where do I put this code in the Subscription screen of Report Manager? Think I'm totally on the wrong wavelength here!

I've come across this too, and guess which version I have!!! Standard!!! Grrr....

I did manage to get a bit of a cheat for this though. It will require...

Ok. I'll set myself a reminder to check the blog out every few days then. Many thanks.

Thanks Andrew by the way too. Your query now works with that tally table setup.

Makes sense that.

Do you have a link I could navigate to to read your article please? Interested in increasing my knowledge of this part of sql.

Analysed the links to the Tally tables etc now and I think I've got to the bottom of the code now thanks. See how the CTE tally table works now...

andrewd.smith (4/15/2009)

---

This query appears to reproduce your expected results.

It uses a Tally / Numbers table with name Tally that includes the value 0 (zero).

There is a pre-query to retrieve...

Lynn Pettis (4/15/2009)

---

Here is some code for you to examine and play with. I hope it helps.

declare @StartDate datetime,

@EndDate ...

I'd be entering that date as a parameter (as well as the start date of 1st of May 2009 in my example run). Would need to accept two entered dates...

Here you go. I've put the results in an excel format to make it clearer and changed the interval type for the third record from M (monthly) to D (days)...

Anyone able to help me with this or my last comment please?

Florian, thanks for your comment here too, but my reply to Chris' comment applies to yours too. Can you see my test data please?

[font="Tahoma"]I can just about work out what you're doing here. First section declaring the variables, second initialising them, and the third looping through your tally table. In a bit of...