CREATE PROCEDURE GETID 
  @tbl  char(10)
AS
set nocount on
declare @TempId int
UPDATE NumberTable SET 
  @TempID = id_value,
  id_value = id_value + 1
WHERE tablename = @tbl
SELECT @tempid