USP_SIMPLEDATALIST_LIKELIHOODPERCENT

                CREATE procedure dbo.USP_SIMPLEDATALIST_LIKELIHOODPERCENT
                as
                    set nocount on;

                    select
                        LIKELIHOODTYPECODE.ID as VALUE,
                        LIKELIHOODTYPECODE.DESCRIPTION + 
                            case when LIKELIHOODPERCENT.[PERCENT] is not null 
                                then ' (' + convert(nvarchar(3), LIKELIHOODPERCENT.[PERCENT]) + '%)'
                                else '' end as LABEL
                    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]