Link to home
Start Free TrialLog in
Avatar of traci1234
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
ASKER CERTIFIED SOLUTION
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.