Posted by Driesen via SQLMonster.com on 06/14/28 11:28

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.aspx/sql-server-general/200510/1

• Next in forum: Display Money Type using + and -
• Prev in forum: Re: Error handling when calling external sql-Files
• Thread view: Re: Trouble with SPROC

[Reply to this message]