How should I reserve a set of "next numbers"?

Question

How should I reserve a set of "next numbers"?

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 1

Ah... found it in a 12 year old post of mine. Please see the following post. You can also replace the vendor's code and eliminate the possibility of getting the wrong ID by converting the variables (like the increment) to hard coded values (1 for the increment). You should probably ignore the code that uses a cursor after that. You can do all sorts of stuff without one.
https://www.sqlservercentral.com/Forums/Topic418139-8-1.aspx#bm418200

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Chris Wooding SSCarpal Tunnel Points: 4599 More actions · Answer 2

Thanks all. I have some things to try once I have write access to a development copy of the database.