/*

This code generates all missing ID #'s in table.

UniqueID: column name of your unique ID

SourceTable: name of your table with ID's

*/

declare @LastID int

select

@LastID =...