I have some code that is not executing properly and I think it's because of
the large number of EXEC('Update....') statements I have in the proc. The
proc is basically structured with 4 straight updates at the beginning followed
by probably 32 or so EXEC('Update...') statements -- finished off by a straight
update. I'm thinking about breaking the EXEC statements off into it's own
proc to clean up the problem. Has anyone else seen this problem with procs
using a large number of EXEC statments. I'm using the EXEC statements to
build the SQL on the fly.

Kristin Piskulic