#DateForumTypeThreadPost
530 Jan 2015 @ 11:26 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsThanks Dieter. I love your solution. This is a refined version of what I wanted to do, and would prefer to do. The project team decided that we're going with a loop in the store...
420 Jan 2015 @ 02:14 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsThe stored procedure I am working with is using an insert select.
320 Jan 2015 @ 12:11 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsokay so I found this page: http://stackoverflow.com/questions/4340793/how-to-find-gaps-in-sequential-numbering-in-mysql and modified their query like so select top 1 gap_start from (  ...
219 Jan 2015 @ 11:57 PSTDatabaseReplySeeking ideas: need to grab next available UPI for insertsHello, thanks for your help.   Apparently my DBA does not like the idea of re creating the table.   Is there any option that will take the next available number instead of using the h...
117 Jan 2015 @ 11:58 PSTDatabaseTopicSeeking ideas: need to grab next available UPI for insertsHello, I am a developer hoping to get some help with ideas to devise an elegant way of grabbing the next available Unique Primary Index for inserts to a table which is quite old and large that dri...