I have a procedure that is scheduled to run hourly and accesses production tables used by our order entry application. This procedure populates a table that is used by a crystal report (report runs hourly as well).
I've run into blocking problems.
I've tried to make the procedure as agressive as possible (dump data from production tables into temp tables, create cursor after temp tables are created, I've issued no lock statements after all tables). I'm not sure to where to go from here. Any help is appreciated.
Thanks
I've run into blocking problems.
I've tried to make the procedure as agressive as possible (dump data from production tables into temp tables, create cursor after temp tables are created, I've issued no lock statements after all tables). I'm not sure to where to go from here. Any help is appreciated.
Thanks