UFN_BBNC_GETPROFILEUPDATECOUNTBYBACKOFFICEID

CREATE function dbo.UFN_BBNC_GETPROFILEUPDATECOUNTBYBACKOFFICEID
(
  @BACKOFFICEID integer
)
returns integer

as begin
    return 
  (
    select 
      COUNT(*)
    from
      dbo.BATCHBBNCPROFILE
      inner join dbo.BATCH on BATCH.ID = BATCHBBNCPROFILE.BATCHID
      left join dbo.CONSTITUENT on BATCHBBNCPROFILE.LINKID = CONSTITUENT.ID
    where
      CONSTITUENT.SEQUENCEID = @BACKOFFICEID
      and BATCH.STATUSCODE = 0
  )
end