Posted by Roy Harvey on 10/29/06 12:21

Unless you provide table definitions and the code it is unlikely that
anyone will be able to help very much.

>I then loop through the table variable to process all the records with
>the particular key value.

It sounds as though this "process" is where things go bad, but all we
know about the process is that it loops. Looping sounds like cursors.
(Cursors are powerful and indispensable tools - but are often
misused.)

There are other possible hints in the description.... building a table
of keys instead of (potentially) using a derived table or view, using
a table variable with 3000 values, the fact that the processing of the
different tables is similar but apparently different brings the
cohesion of the procedure into question.... but without specifics it
isn't even worth guessing.

Roy Harvey
Beacon Falls, CT

[Back to original message]