UFN_PDACCOUNTSTRUCTURE_NUMBEROFSEGMENTS2

Returns the number of segments that make up an account string

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PDACCOUNTSTRUCTURE_NUMBEROFSEGMENTS2(@ID uniqueidentifier)
            returns int
            with execute as caller
            as begin
                return (select count(*) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID=@ID)
            end