Thank you for very useful post. I have previously had to deal with SSRS Migrations (which were migrated by others) where my biggest gripe was that they failed to migrate...

Excuse my ignorance, not having used 2016 yet in anger, why would you need to do this?

Thanks again for your response.

Managed to get it working so thought it might be useful to somebody else one day if I post code back here

Thank you both for your response.

Note ... I have altered the code in my original post as I realised  it should have  had the Variable  instead of...

Love it.

Would love a similar script for that I can use for Oracle.

Really like the script and wanted to thank you for this.

Not sure about turning database mail functionality off, appreciate that if anybody hacks system they can send email to anybody,...

Thank you very much for your very quick response. Much appreciated. Tried it today at work and just made a few minor modifications but essentially it worked a treat.

Also makes...

Thank you for your response. Apologies I had not seen your response. I went down the route of using several selects joined with a union, but will give this a...

Thanks for sharing the script.

Whilst I appreciate what you are doing and that you have shared your script, I am just wondering if it is not simpler and safer...

Thank you for your script, must have taken some time to do. Much appreciated.

I do agree with Mike Hinds and ScottPletcher about changing the settings on xp_cmdshell, although I would...

I think it is quite handy that this can be done in SQL.

I agree there are other tools that can and have been written already that probably do a much...

Msg 208, Level 16, State 1, Line 21

Invalid object name 'dbo.CalDay'.

SQL Server 2005 Express (with SSMS 2008)

Fantastic. that sorted it.

Thanks so much for looking into this.

SQL Server Express 2005 for testing

Apologies if this is a silly question. But I seem to get the following error when running your script

Msg 243, Level 16, State 1, Procedure ufn_inltab_getGregorianEasterSunday, Line 4

Type DATE is...