USP_CODETABLE_NORMALIZEALLSEQUENCES

create procedure dbo.USP_CODETABLE_NORMALIZEALLSEQUENCES
(
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    declare @TABLENAME nvarchar(100);
    declare @SQL nvarchar(500);
    declare @PARAMDEF nvarchar(500);

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    set @PARAMDEF = N'@CHANGEAGENTID uniqueidentifier';

    declare CODE_TABLES cursor for
    select DBTABLENAME
    from dbo.CODETABLECATALOG;

    open CODE_TABLES;

    fetch next from CODE_TABLES into @TABLENAME;
    while (@@FETCH_STATUS <> -1)
    begin

        set @SQL = N'exec dbo.USP_' + @TABLENAME + '_NORMALIZESEQUENCENUMBERS @CHANGEAGENTID';

        exec sp_executesql @SQL, @PARAMDEF, @CHANGEAGENTID = @CHANGEAGENTID;

        fetch next from CODE_TABLES into @TABLENAME;
    end;
    close CODE_TABLES;
    deallocate CODE_TABLES;
end;