I have a store proc that that does various bits of data manipulation, but the last part I have used a cursor to update 2 fields in a table. This sp is called by a VB front end and then the contents of the table in question displayed in a Crystal Report.
The problem is, if I run the sp directly (within VB's Server Explorer) these 2 fields are always fully populated. If however I call the sp from within code in a GUI, after each call (which should fully populate the table based on certain criteria) the 2 fields become less populated. What I mean by this is on the 1st call the 2 fields are 100% populated, with each subsequent call only populating maybe 50% of records, then 20%, until no records are populated.