Simon E Doubt (4/4/2014)
Have you thought of using SSIS and the RS scripting utility?
I developed a solution using that technique to render PDF versions of a specific report once per month.
Do some Googling for Rs.exe or Rs Utility and you'll find the scripting language is quite powerful.
Should be able to accommodate what you need.
Thanks Simon - probably a good idea, but learning how to script the job would probably take me longer than working out how a piece of sql would work (and that is bad enough
I managed to get it working ONCE with the code here
but have since hit sharepoint OSWS timer errors and it hasn't sent emails since