My coworker want us to create a report that gets emailed to him every Monday through SQL. I don't know the best way to do this or where to start trying to join whatever activity table and the Opportunity table.
He just wants the simple fields from Actities like Subject, Actvity type, Activity Status, Priority, Actual end date, creaged by Modified by Date created (which will be the date range) then joing the Opportunity table, with the close date of the opportunity,
date recieved etc.
Please guide me in the right direction on what would be the best way. I would thing through the report system, but not sure how to have that get emailed. However, I would like to know how to do this through SQL too.