Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Insert query and Cursor in same stored procedure

Database

21 Posts 4 Posters 0 Views 1 Watching

J Jay Royall

This works great when inserting a new record and then updating each sequence but not when changing an existing record's sequence and then updating all the other sequences. But, with my new found knowledge, I'm sure that I'll work it out! Thanks again all for your help.
W Offline
W Offline
Wendelius

wrote on last edited by

#21

Liqz wrote:

, with my new found knowledge, I'm sure that I'll work it out!

I'm confident that you will :)

Liqz wrote:

Thanks again all for your help

No problem.

The need to optimize rises from a bad design.My articles[^]
1 Reply Last reply

0