UFN_PDACCOUNTSEGMENTMAPPING_VERIFYSEGMENTVALUE

CREATE function dbo.UFN_PDACCOUNTSEGMENTMAPPING_VERIFYSEGMENTVALUE(@STRUCTUREID uniqueidentifier, @SEGMENTVALUEID uniqueidentifier) returns bit
as
begin
    if @SEGMENTVALUEID is null
        return 1

    if exists(select T1.ID from PDACCOUNTSEGMENTVALUE T1
        inner join PDACCOUNTSTRUCTURE T2 ON T1.PDACCOUNTSTRUCTUREID=T2.ID
        where T1.ID = @SEGMENTVALUEID and T2.ID=@STRUCTUREID)
            return 1

    return 0
end