USP_SIMPLEDATALIST_PROSPECTFUNDINGINTEREST

                CREATE procedure dbo.USP_SIMPLEDATALIST_PROSPECTFUNDINGINTEREST
                (
                  @PROSPECTID uniqueidentifier
                )
                as
                    set nocount on;

                    select
                        PROSPECTFUNDINGINTEREST.ID as 'VALUE',
                        dbo.UFN_FUNDINGTYPECODE_GETDESCRIPTION(PROSPECTFUNDINGINTEREST.FUNDINGTYPECODEID) + ' (' + PROSPECTFUNDINGINTEREST.INTERESTLEVEL + ')' as 'LABEL'
                    from
                        dbo.PROSPECTFUNDINGINTEREST
                    where
                        PROSPECTFUNDINGINTEREST.PROSPECTID = @PROSPECTID
                    order by
                        'LABEL'