UFN_PROSPECTPLAN_GETFUNDRAISERID_FROM_OWNERID

      CREATE function dbo.UFN_PROSPECTPLAN_GETFUNDRAISERID_FROM_OWNERID(
        @FUNDRAISERROLEID uniqueidentifier,
        @PLANID uniqueidentifier)
 returns table
 as return
 (
    select 
    (case when @FUNDRAISERROLEID = 'fd85801a-7104-4fb3-b79f-bca674f65c3d' then
            (select top 1 PP.PRIMARYMANAGERFUNDRAISERID from dbo.PROSPECTPLAN PP where PP.ID= @PLANID)
          when @FUNDRAISERROLEID = 'c7b573a0-220f-48c5-9055-b7b437289ee6' then
            (select top 1 P.PROSPECTMANAGERFUNDRAISERID from dbo.PROSPECTPLAN PP left outer join dbo.PROSPECT P on P.ID=PP.PROSPECTID where PP.ID= @PLANID)
          when @FUNDRAISERROLEID = 'b372cc41-ea52-48f0-8564-47842a38332a' then
            (select top 1 PP.SECONDARYMANAGERFUNDRAISERID from dbo.PROSPECTPLAN PP where PP.ID= @PLANID)
          when @FUNDRAISERROLEID = 'e8107043-1238-46aa-9b48-221b36c91e9e' then
            (select top 1 SF.FUNDRAISERID from dbo.PROSPECTPLAN PP left outer join dbo.SECONDARYFUNDRAISER SF on SF.PROSPECTPLANID=PP.ID where PP.ID= @PLANID)
          else
            @FUNDRAISERROLEID
     end
    ) as FUNDRAISERID
 )