te acountsreceivables part of the query is pretty odd...

THanks so much for this - I am going to add a few parameters (default is the way you ran it) but running it for a multi select of jobs...

I also enjoy the content here - at least several times a week some good info that I use - http://blog.sqlauthority.com/

actually - I DO have a CS 4 year degree... but then I am not JUST a DBA - I also help a fair amount with accounting, manufacturing, revenue reporting......

I took a different way out a while back - I have a job that just runs a series of emails - this one is hard coded going to me...

love this for our sql machines - it would be nice to be able to figure out how to incorporate this type of solution into all of our other servers......