Re: SP not seeing INSERTs within WHILE loop

2007-01-05 Thread ViSolve DB Team
Hi, Your procedure returned correct numbers. Does misrepresentation happens for all the runs or adhoc. Thanks ViSolve DB Team. - Original Message - From: "brian stone" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 03, 2007 8:55 AM Subject: SP not seeing INSERTs w

SP not seeing INSERTs within WHILE loop

2007-01-02 Thread brian stone
I have an issue where inserts are not being seen properly while in a SP. The goal is to track payments made by customers, payment distribution. I narrowed down the issue to the below, so I was able to exclude many columns and other tables in hopes it is simple enough to get some help. I have