USP_DATALIST_LIKELIHOODPERCENT

                    CREATE procedure dbo.USP_DATALIST_LIKELIHOODPERCENT 
                    as 
                        set nocount on;

                        select
                            LIKELIHOODTYPECODE.ID,
                            LIKELIHOODTYPECODE.DESCRIPTION,
                            LIKELIHOODPERCENT.[PERCENT]
                        from
                            dbo.LIKELIHOODTYPECODE
                            left join dbo.LIKELIHOODPERCENT on LIKELIHOODTYPECODE.ID = LIKELIHOODPERCENT.ID
                        where
                            LIKELIHOODTYPECODE.ACTIVE = 1
                        order by
                            case when dbo.UFN_GETLISTSORTMETHOD('LIKELIHOODTYPECODE') = 0 then LIKELIHOODPERCENT.[PERCENT] else LIKELIHOODTYPECODE.[SEQUENCE] end, LIKELIHOODTYPECODE.[DESCRIPTION]