USP_BBNC_SIGNUP_GETROWBBNCIDS

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN
Definition

Copy


      CREATE procedure dbo.USP_BBNC_SIGNUP_GETROWBBNCIDS(@BATCHID uniqueidentifier)
      as
      begin
          if exists(select bbnc.BBNCID as VALUE from dbo.BATCHCONSTITUENTUPDATE cub inner join dbo.BATCHCONSTITUENTUPDATEBBNCINFO bbnc on cub.ID = bbnc.BATCHCONSTITUENTUPDATEID where BATCHID = @BATCHID) 
          begin
            select
                          bbnc.BBNCID as VALUE
                      from
                          dbo.BATCHCONSTITUENTUPDATE cub inner join
                          dbo.BATCHCONSTITUENTUPDATEBBNCINFO bbnc on cub.ID = bbnc.BATCHCONSTITUENTUPDATEID
                      where
                          BATCHID = @BATCHID
          end
        if not exists (select bbnc.BBNCID as VALUE from dbo.BATCHCONSTITUENTUPDATE cub inner join dbo.BATCHCONSTITUENTUPDATEBBNCINFO bbnc on cub.ID = bbnc.BATCHCONSTITUENTUPDATEID where BATCHID = @BATCHID)
          begin
            select
                          [BBNCID] as VALUE
                      from
                          dbo.BATCHBBNCSIGNUP
                      where
                          [BATCHID] = @BATCHID
          end
      end