quote:
Thanks MW.I'm using stored procedures and the logic looks simple enough. Maybe 24 hours is as good as it gets.
100,000 rows is not a lot. And to comment on if 24hours is resonable I would say no. However, crcumstances with what you are doing and your specific data may mean otherwise. If you could post the code and a sampling of the data (can be altered) along with an idea of the expected results someone will generally take a stab at what may be done to speed things up.