traci1234
asked on
Speed up stored procedure
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
Weekly-Sales.txt
This will be a report within SQL Reporting Services
Weekly-Sales.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.