UFN_LIKELIHOODPERCENTS_SEQUENCE

Returns likelihoods and their corresponding percent values ordered by a customer user sequence.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_LIKELIHOODPERCENTS_SEQUENCE()
            returns table 
            as return
                select 
                    LIKELIHOODTYPECODE.ID, 
                    LIKELIHOODTYPECODE.DESCRIPTION,
                    LIKELIHOODPERCENT.[PERCENT],
                    LIKELIHOODTYPECODE.SEQUENCE
                from 
                    dbo.LIKELIHOODTYPECODE
                    left join dbo.LIKELIHOODPERCENT on LIKELIHOODTYPECODE.ID = LIKELIHOODPERCENT.ID
                where
                    LIKELIHOODTYPECODE.ACTIVE = 1