UFN_LIKELIHOODPERCENTS

            CREATE function dbo.UFN_LIKELIHOODPERCENTS()
            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