I have a stored procedure that I need to return occupancy, sales, etc. by Community (80+) by week for an entire year. Currently I have two loops (1 for community, 1 for weekly dates) but it runs in 1 hour plus and I need the performance to speed up. I have attached a copy of the current procedure.
This will be a report within SQL Reporting Services