Thanks for the responses guys.

Just what I needed.

BO

Yes, you are of course right, tweaked and now does what I need.

Thanks guys.

BO

Hi john

It is actually both of those things. I need a single row for...

Many thanks John - really, really helpful.

Yes, afraid so ;(

Is it possible to limit it and just bring back the first 10 date columns with calculations then?

Hi John

No, they can have many diffrent dates.

BO

Hi Eirikiur
This is a great solution but not quite what I was after.
Is it possible to have each of the date fields in spartae columns along wth the...

Thanks for the responses guys.

I have gone with your suggestion Ponnuru - thanks for setting it out in such detail.

BO

Hi

Yeah, I’ve been able to create for each loop containers for a package that creates an Excel output with multiple worksheets and another that creates multiple Excel workbooks. But what...

Thanks guys.

I’ll give the article a read and see where I get.

I’m reluctant to send as attachments myself but the boss likes the idea of the click of...

Thanks for sending the SQL.

It works brilliantly and I've adapted my script.

BO

Thanks so much for replying so speedily.

That seems to work perfectly!

Thanks again

BO

Awesome.

I will play around with both options.

Thanks again for alll your help.

BO

Des - this is perfect - thank you so much for your help - much, much appreciated!

BO