UFN_BBIS_GETAPPEALIDFROMEMAILID

create function dbo.UFN_BBIS_GETAPPEALIDFROMEMAILID
(
  @EMAILID int
)
returns uniqueidentifier
as
            begin
                return 
                (
                    select top 1 AP.ID
          from dbo.Email EM
          inner join BBNCAPPEALIDMAP MAP on MAP.ID = EM.AppealID
          inner join APPEAL AP on AP.ID = MAP.APPEALID
          where EM.ID = @EMAILID
                );
            end