Hi there,

Thanks for that... I was thinking that I could write the copying and file rewrite in TSQL, keeping it all clean and together.

But if that is the preferred option...

Thanks for the replies.

I have a calendar table.

When I calculate 20 days from the start date to get my end date.

Then add my hols and weekends to get the new...

Theme | Theme2 | NoOfResults

Counting (NoOfResults) how many Theme2s are paired with Theme