USP_BBNC_GETPRIMARYEMAIL

CREATE procedure dbo.USP_BBNC_GETPRIMARYEMAIL
(
  @MAPID integer
)
as
begin
  select
    ea.ID,
    ea.EMAILADDRESSTYPECODEID,
    ea.EMAILADDRESS,
    bbnc.ID as MAPID
  from 
    dbo.EMAILADDRESS ea
  left join
    dbo.CONSTITUENT c on ea.CONSTITUENTID = c.ID
  left join
      dbo.BBNCCODETABLEIDMAP bbnc on bbnc.TABLEENTRYID = ea.EMAILADDRESSTYPECODEID
  where
    c.SEQUENCEID = @MAPID and ea.ISPRIMARY = 1
end