UFN_FAFWEBSITE_ISIMPORTSUCCESS

CREATE function dbo.UFN_FAFWEBSITE_ISIMPORTSUCCESS(@EVENTID uniqueidentifier)
returns bit
with execute as caller
as begin
    declare @ISIMPORTSUCCESS bit

  select 
    @ISIMPORTSUCCESS = CASE WHEN ISNULL(PM.LASTIMPORTERROR,'') = '' then 1 else 0 end
  from dbo.EVENTEXTENSION EX 
  join dbo.ClientSites CS on EX.CLIENTSITESID = CS.ID 
  left join dbo.PAGEMODEL PM on CS.ID = PM.CLIENTSITESID
  left join dbo.CMSSITESETTING CMS2 on CS.ID = CMS2.CLIENTSITESID and CMS2.ENUMID = 2
  left join dbo.CMSSITESETTING CMS3 on CS.ID = CMS3.CLIENTSITESID and CMS3.ENUMID = 3
  where EX.EVENTID = @EVENTID

    return @ISIMPORTSUCCESS
end