USP_BBNC_DONATION_GETROWBBNCIDS

      CREATE procedure dbo.USP_BBNC_DONATION_GETROWBBNCIDS(@BATCHID uniqueidentifier)
      as
      begin
          if exists(select 1 from dbo.BATCHREVENUE br inner join dbo.BATCHREVENUEBBNCINFO bbnc on br.ID = bbnc.BATCHREVENUEID where BATCHID = @BATCHID) 
          begin
            select 
              bbnc.BBNCID as VALUE
            from 
              dbo.BATCHREVENUE br inner join
              dbo.BATCHREVENUEBBNCINFO bbnc on br.ID = bbnc.BATCHREVENUEID
            where 
              BATCHID = @BATCHID
          end
        if not exists (select 1 from dbo.BATCHREVENUE br inner join dbo.BATCHREVENUEBBNCINFO bbnc on br.ID = bbnc.BATCHREVENUEID where BATCHID = @BATCHID)
          begin
            select
                  [BBNCID] as VALUE
              from
                  dbo.BATCHBBNCDONATION
              where
                  [BATCHID] = @BATCHID
          end
      end