UFN_PDACCOUNTSTRUCTURE_GETTABLENUMBER

Get next sequential tablenumber for segments

Return

Return Type
int

Definition

Copy



CREATE function dbo.UFN_PDACCOUNTSTRUCTURE_GETTABLENUMBER()
returns integer
with execute as caller
as begin
    declare @NUMBER integer = 0;

    select @NUMBER = count (ID) from dbo.PDACCOUNTSTRUCTURE    where PDACCOUNTSYSTEMID='4B121C2C-CCE6-440D-894C-EA0DEF80D50B'    
    return @NUMBER + 1
end