All,<BR><BR>First, apologies for the ugliness of the below.. I'm no expert!<BR><BR>To summarize, I'm trying to build a query I can run that I can run from the SQL Agent to email me daily reports..