Hi Hugo
Thanks very much for the tips. I thought I was being safe by using all those
SELECT statements. I had no idea that my resources were being chunked. I am
going to look at re-writing all my procedures using your recommendations. As
for my original posting, I re-wrote the entire procedure and it seems to work
now. It looks exactly the same as the other one.
Thanks a million for all the help, Hugo.
Driesen
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...neral/200510/1