UFN_BATCH_HASBATCHEXCEPTION

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:05:41 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE function dbo.UFN_BATCH_HASBATCHEXCEPTION(@BATCHID uniqueidentifier)
returns bit
with execute as caller
as begin
    declare @BATCHTYPECATALOGID uniqueidentifier
    declare @COUNT int

    select 
        @BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    from 
        dbo.BATCH 
        inner join dbo.BATCHTEMPLATE on BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID
        inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
    where
        BATCH.ID = @BATCHID;    

    if @BATCHTYPECATALOGID = '877dbc83-98f9-4008-98a0-902fdb35e819' begin -- Constituent Update Batch

select @count = count(BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHCONSTITUENTUPDATE inner join dbo.BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES on BATCHCONSTITUENTUPDATEBATCHSYSTEMMESSAGES.BATCHCONSTITUENTUPDATEID = BATCHCONSTITUENTUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHCONSTITUENTUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHCONSTITUENTUPDATE inner join dbo.BATCHCONSTITUENTUPDATEBATCHUSERMESSAGE on BATCHCONSTITUENTUPDATEBATCHUSERMESSAGE.ID = BATCHCONSTITUENTUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '5e1e01e1-b149-4582-a1e3-42ae8cd6129d' begin -- Giving Summary Update Batch

select @count = count(BATCHGIVINGSUMMARYUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHGIVINGSUMMARYUPDATE inner join dbo.BATCHGIVINGSUMMARYUPDATEBATCHSYSTEMMESSAGES on BATCHGIVINGSUMMARYUPDATEBATCHSYSTEMMESSAGES.BATCHGIVINGSUMMARYUPDATEID = BATCHGIVINGSUMMARYUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHGIVINGSUMMARYUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHGIVINGSUMMARYUPDATE inner join dbo.BATCHGIVINGSUMMARYUPDATEBATCHUSERMESSAGE on BATCHGIVINGSUMMARYUPDATEBATCHUSERMESSAGE.ID = BATCHGIVINGSUMMARYUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '85fb9c19-ddc4-4fab-a2d4-e8b0bbb46ec6' begin -- Model Scores and Ratings Update Batch

select @count = count(BATCHMODELINGANDPROPENSITYUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHMODELINGANDPROPENSITYUPDATE inner join dbo.BATCHMODELINGANDPROPENSITYUPDATEBATCHSYSTEMMESSAGES on BATCHMODELINGANDPROPENSITYUPDATEBATCHSYSTEMMESSAGES.BATCHMODELINGANDPROPENSITYUPDATEID = BATCHMODELINGANDPROPENSITYUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHMODELINGANDPROPENSITYUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHMODELINGANDPROPENSITYUPDATE inner join dbo.BATCHMODELINGANDPROPENSITYUPDATEBATCHUSERMESSAGE on BATCHMODELINGANDPROPENSITYUPDATEBATCHUSERMESSAGE.ID = BATCHMODELINGANDPROPENSITYUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'a9d52b88-2351-4964-b4cd-ace37f4aa2d8' begin -- Educational History Update Batch

select @count = count(BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHEDUCATIONALHISTORYUPDATE inner join dbo.BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES on BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES.BATCHEDUCATIONALHISTORYUPDATEID = BATCHEDUCATIONALHISTORYUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHEDUCATIONALHISTORYUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHEDUCATIONALHISTORYUPDATE inner join dbo.BATCHEDUCATIONALHISTORYUPDATEBATCHUSERMESSAGE on BATCHEDUCATIONALHISTORYUPDATEBATCHUSERMESSAGE.ID = BATCHEDUCATIONALHISTORYUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'a979005c-d15d-4a8a-8173-200318bb453a' begin -- Constituent Batch

select @count = count(BATCHCONSTITUENTBATCHSYSTEMMESSAGES.ID) from dbo.BATCHCONSTITUENT inner join dbo.BATCHCONSTITUENTBATCHSYSTEMMESSAGES on BATCHCONSTITUENTBATCHSYSTEMMESSAGES.BATCHCONSTITUENTID = BATCHCONSTITUENT.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHCONSTITUENTBATCHUSERMESSAGE.ID) from dbo.BATCHCONSTITUENT inner join dbo.BATCHCONSTITUENTBATCHUSERMESSAGE on BATCHCONSTITUENTBATCHUSERMESSAGE.ID = BATCHCONSTITUENT.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '4f35697d-a872-43fd-b5f3-0ab185eefc2b' begin -- Address Validation Batch

select @count = count(BATCHADDRESSVALIDATIONBATCHSYSTEMMESSAGES.ID) from dbo.BATCHADDRESSVALIDATION inner join dbo.BATCHADDRESSVALIDATIONBATCHSYSTEMMESSAGES on BATCHADDRESSVALIDATIONBATCHSYSTEMMESSAGES.BATCHADDRESSVALIDATIONID = BATCHADDRESSVALIDATION.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHADDRESSVALIDATIONBATCHUSERMESSAGE.ID) from dbo.BATCHADDRESSVALIDATION inner join dbo.BATCHADDRESSVALIDATIONBATCHUSERMESSAGE on BATCHADDRESSVALIDATIONBATCHUSERMESSAGE.ID = BATCHADDRESSVALIDATION.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '721c4686-8574-4456-a9af-4da79d94a0e6' begin -- AddressFinder Batch

select @count = count(BATCHCOAUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHCOAUPDATE inner join dbo.BATCHCOAUPDATEBATCHSYSTEMMESSAGES on BATCHCOAUPDATEBATCHSYSTEMMESSAGES.BATCHCOAUPDATEID = BATCHCOAUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHCOAUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHCOAUPDATE inner join dbo.BATCHCOAUPDATEBATCHUSERMESSAGE on BATCHCOAUPDATEBATCHUSERMESSAGE.ID = BATCHCOAUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'da6e4cd6-75ab-4d2b-a45d-996a40eb2a91' begin -- Constituent Address Update Batch

select @count = count(BATCHCONSTITUENTADDRESSUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHCONSTITUENTADDRESSUPDATE inner join dbo.BATCHCONSTITUENTADDRESSUPDATEBATCHSYSTEMMESSAGES on BATCHCONSTITUENTADDRESSUPDATEBATCHSYSTEMMESSAGES.BATCHCONSTITUENTADDRESSUPDATEID = BATCHCONSTITUENTADDRESSUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHCONSTITUENTADDRESSUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHCONSTITUENTADDRESSUPDATE inner join dbo.BATCHCONSTITUENTADDRESSUPDATEBATCHUSERMESSAGE on BATCHCONSTITUENTADDRESSUPDATEBATCHUSERMESSAGE.ID = BATCHCONSTITUENTADDRESSUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'cae84ec7-c986-43cf-abe1-2974a91a6ea8' begin -- DeceasedRecordFinder Batch

select @count = count(BATCHDECEASEDFINDERBATCHSYSTEMMESSAGES.ID) from dbo.BATCHDECEASEDFINDER inner join dbo.BATCHDECEASEDFINDERBATCHSYSTEMMESSAGES on BATCHDECEASEDFINDERBATCHSYSTEMMESSAGES.BATCHDECEASEDFINDERID = BATCHDECEASEDFINDER.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHDECEASEDFINDERBATCHUSERMESSAGE.ID) from dbo.BATCHDECEASEDFINDER inner join dbo.BATCHDECEASEDFINDERBATCHUSERMESSAGE on BATCHDECEASEDFINDERBATCHUSERMESSAGE.ID = BATCHDECEASEDFINDER.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '066b20cb-e9aa-46f5-b050-5fb4cb1cac7e' begin -- Direct Debit Return Batch

select @count = count(BATCHDIRECTDEBITRETURNBATCHSYSTEMMESSAGES.ID) from dbo.BATCHDIRECTDEBITRETURN inner join dbo.BATCHDIRECTDEBITRETURNBATCHSYSTEMMESSAGES on BATCHDIRECTDEBITRETURNBATCHSYSTEMMESSAGES.BATCHDIRECTDEBITRETURNID = BATCHDIRECTDEBITRETURN.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHDIRECTDEBITRETURNBATCHUSERMESSAGE.ID) from dbo.BATCHDIRECTDEBITRETURN inner join dbo.BATCHDIRECTDEBITRETURNBATCHUSERMESSAGE on BATCHDIRECTDEBITRETURNBATCHUSERMESSAGE.ID = BATCHDIRECTDEBITRETURN.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'd1b2831e-74d2-4f29-8420-470f964e80f0' begin -- Exchange Calendar Item Batch

select @count = count(EXCHANGECALENDARITEMBATCHBATCHSYSTEMMESSAGES.ID) from dbo.EXCHANGECALENDARITEMBATCH inner join dbo.EXCHANGECALENDARITEMBATCHBATCHSYSTEMMESSAGES on EXCHANGECALENDARITEMBATCHBATCHSYSTEMMESSAGES.EXCHANGECALENDARITEMBATCHID = EXCHANGECALENDARITEMBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(EXCHANGECALENDARITEMBATCHBATCHUSERMESSAGE.ID) from dbo.EXCHANGECALENDARITEMBATCH inner join dbo.EXCHANGECALENDARITEMBATCHBATCHUSERMESSAGE on EXCHANGECALENDARITEMBATCHBATCHUSERMESSAGE.ID = EXCHANGECALENDARITEMBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'e724fd73-02cb-4d3e-8348-d46feee797cd' begin -- Exchange Contact Update Batch

select @count = count(EXCHANGECONTACTBATCHBATCHSYSTEMMESSAGES.ID) from dbo.EXCHANGECONTACTBATCH inner join dbo.EXCHANGECONTACTBATCHBATCHSYSTEMMESSAGES on EXCHANGECONTACTBATCHBATCHSYSTEMMESSAGES.EXCHANGECONTACTBATCHID = EXCHANGECONTACTBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(EXCHANGECONTACTBATCHBATCHUSERMESSAGE.ID) from dbo.EXCHANGECONTACTBATCH inner join dbo.EXCHANGECONTACTBATCHBATCHUSERMESSAGE on EXCHANGECONTACTBATCHBATCHUSERMESSAGE.ID = EXCHANGECONTACTBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '6004f2dc-a8d1-4a69-a795-71f347c35bf3' begin -- Exchange Email Batch

select @count = count(EXCHANGEEMAILBATCHBATCHSYSTEMMESSAGES.ID) from dbo.EXCHANGEEMAILBATCH inner join dbo.EXCHANGEEMAILBATCHBATCHSYSTEMMESSAGES on EXCHANGEEMAILBATCHBATCHSYSTEMMESSAGES.EXCHANGEEMAILBATCHID = EXCHANGEEMAILBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(EXCHANGEEMAILBATCHBATCHUSERMESSAGE.ID) from dbo.EXCHANGEEMAILBATCH inner join dbo.EXCHANGEEMAILBATCHBATCHUSERMESSAGE on EXCHANGEEMAILBATCHBATCHUSERMESSAGE.ID = EXCHANGEEMAILBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'ed528f81-ca26-4daf-b455-95af3e0d12d5' begin -- Fundraising Purpose Financial Info Batch

select @count = count(BATCHDESIGNATIONLEVELFINANCIALINFOBATCHSYSTEMMESSAGES.ID) from dbo.BATCHDESIGNATIONLEVELFINANCIALINFO inner join dbo.BATCHDESIGNATIONLEVELFINANCIALINFOBATCHSYSTEMMESSAGES on BATCHDESIGNATIONLEVELFINANCIALINFOBATCHSYSTEMMESSAGES.BATCHDESIGNATIONLEVELFINANCIALINFOID = BATCHDESIGNATIONLEVELFINANCIALINFO.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHDESIGNATIONLEVELFINANCIALINFOBATCHUSERMESSAGE.ID) from dbo.BATCHDESIGNATIONLEVELFINANCIALINFO inner join dbo.BATCHDESIGNATIONLEVELFINANCIALINFOBATCHUSERMESSAGE on BATCHDESIGNATIONLEVELFINANCIALINFOBATCHUSERMESSAGE.ID = BATCHDESIGNATIONLEVELFINANCIALINFO.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '454f688a-8a9a-4fe2-acc5-fa28c1e71836' begin -- Model Scores and Ratings Batch

select @count = count(BATCHMODELINGANDPROPENSITYBATCHSYSTEMMESSAGES.ID) from dbo.BATCHMODELINGANDPROPENSITY inner join dbo.BATCHMODELINGANDPROPENSITYBATCHSYSTEMMESSAGES on BATCHMODELINGANDPROPENSITYBATCHSYSTEMMESSAGES.BATCHMODELINGANDPROPENSITYID = BATCHMODELINGANDPROPENSITY.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHMODELINGANDPROPENSITYBATCHUSERMESSAGE.ID) from dbo.BATCHMODELINGANDPROPENSITY inner join dbo.BATCHMODELINGANDPROPENSITYBATCHUSERMESSAGE on BATCHMODELINGANDPROPENSITYBATCHUSERMESSAGE.ID = BATCHMODELINGANDPROPENSITY.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '91102efd-e0e9-467f-b2ca-8b510d06c937' begin -- BBIS Donation Transaction Batch

select @count = count(BATCHBBNCDONATIONBATCHSYSTEMMESSAGES.ID) from dbo.BATCHBBNCDONATION inner join dbo.BATCHBBNCDONATIONBATCHSYSTEMMESSAGES on BATCHBBNCDONATIONBATCHSYSTEMMESSAGES.BATCHBBNCDONATIONID = BATCHBBNCDONATION.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHBBNCDONATIONBATCHUSERMESSAGE.ID) from dbo.BATCHBBNCDONATION inner join dbo.BATCHBBNCDONATIONBATCHUSERMESSAGE on BATCHBBNCDONATIONBATCHUSERMESSAGE.ID = BATCHBBNCDONATION.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'c66c39bc-acd1-4c30-98db-c5ba8f90ebec' begin -- BBIS Event Registration Transaction Batch

select @count = count(BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGES.ID) from dbo.BATCHBBNCEVENTREGISTRATION inner join dbo.BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGES on BATCHBBNCEVENTREGISTRATIONBATCHSYSTEMMESSAGES.BATCHBBNCEVENTREGISTRATIONID = BATCHBBNCEVENTREGISTRATION.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHBBNCEVENTREGISTRATIONBATCHUSERMESSAGE.ID) from dbo.BATCHBBNCEVENTREGISTRATION inner join dbo.BATCHBBNCEVENTREGISTRATIONBATCHUSERMESSAGE on BATCHBBNCEVENTREGISTRATIONBATCHUSERMESSAGE.ID = BATCHBBNCEVENTREGISTRATION.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'd6b66862-51f8-4706-b586-b2636367c657' begin -- BBIS Membership Transaction Batch

select @count = count(BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGES.ID) from dbo.BATCHBBNCMEMBERSHIP inner join dbo.BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGES on BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGES.BATCHBBNCMEMBERSHIPID = BATCHBBNCMEMBERSHIP.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHBBNCMEMBERSHIPBATCHUSERMESSAGE.ID) from dbo.BATCHBBNCMEMBERSHIP inner join dbo.BATCHBBNCMEMBERSHIPBATCHUSERMESSAGE on BATCHBBNCMEMBERSHIPBATCHUSERMESSAGE.ID = BATCHBBNCMEMBERSHIP.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '249ab221-e976-4dc7-b5ed-4445fbf3657b' begin -- BBIS Signup Transaction Batch

select @count = count(BATCHBBNCSIGNUPBATCHSYSTEMMESSAGES.ID) from dbo.BATCHBBNCSIGNUP inner join dbo.BATCHBBNCSIGNUPBATCHSYSTEMMESSAGES on BATCHBBNCSIGNUPBATCHSYSTEMMESSAGES.BATCHBBNCSIGNUPID = BATCHBBNCSIGNUP.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHBBNCSIGNUPBATCHUSERMESSAGE.ID) from dbo.BATCHBBNCSIGNUP inner join dbo.BATCHBBNCSIGNUPBATCHUSERMESSAGE on BATCHBBNCSIGNUPBATCHUSERMESSAGE.ID = BATCHBBNCSIGNUP.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '0a256446-d94f-4985-854d-519026268bc1' begin -- Prospect Research Giving Summary Batch

select @count = count(BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGES.ID) from dbo.BATCHRE7INTEGRATIONGIVINGSUMMARY inner join dbo.BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGES on BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHSYSTEMMESSAGES.BATCHRE7INTEGRATIONGIVINGSUMMARYID = BATCHRE7INTEGRATIONGIVINGSUMMARY.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE.ID) from dbo.BATCHRE7INTEGRATIONGIVINGSUMMARY inner join dbo.BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE on BATCHRE7INTEGRATIONGIVINGSUMMARYBATCHUSERMESSAGE.ID = BATCHRE7INTEGRATIONGIVINGSUMMARY.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '7b507df1-9fc9-4295-982a-75a20aefdb97' begin -- Timesheet Batch

select @count = count(BATCHTIMESHEETBATCHSYSTEMMESSAGES.ID) from dbo.BATCHTIMESHEET inner join dbo.BATCHTIMESHEETBATCHSYSTEMMESSAGES on BATCHTIMESHEETBATCHSYSTEMMESSAGES.BATCHTIMESHEETID = BATCHTIMESHEET.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHTIMESHEETBATCHUSERMESSAGE.ID) from dbo.BATCHTIMESHEET inner join dbo.BATCHTIMESHEETBATCHUSERMESSAGE on BATCHTIMESHEETBATCHUSERMESSAGE.ID = BATCHTIMESHEET.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '1a6ca8f4-5444-4db1-a2b0-72efe6219df2' begin -- Revenue Batch

select @count = count(BATCHREVENUEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHREVENUE inner join dbo.BATCHREVENUEBATCHSYSTEMMESSAGES on BATCHREVENUEBATCHSYSTEMMESSAGES.BATCHREVENUEID = BATCHREVENUE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHREVENUEBATCHUSERMESSAGE.ID) from dbo.BATCHREVENUE inner join dbo.BATCHREVENUEBATCHUSERMESSAGE on BATCHREVENUEBATCHUSERMESSAGE.ID = BATCHREVENUE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '98208e65-8334-4d3a-8496-4175352f1430' begin -- BBIS Profile Update Transaction Batch

select @count = count(BATCHBBNCPROFILEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHBBNCPROFILE inner join dbo.BATCHBBNCPROFILEBATCHSYSTEMMESSAGES on BATCHBBNCPROFILEBATCHSYSTEMMESSAGES.BATCHBBNCPROFILEID = BATCHBBNCPROFILE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHBBNCPROFILEBATCHUSERMESSAGE.ID) from dbo.BATCHBBNCPROFILE inner join dbo.BATCHBBNCPROFILEBATCHUSERMESSAGE on BATCHBBNCPROFILEBATCHUSERMESSAGE.ID = BATCHBBNCPROFILE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '4e6547b3-eed2-411e-a1f9-f56174c9fa20' begin -- Update Multiple Constituents From MatchFinder Online Batch

select @count = count(UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHSYSTEMMESSAGES.ID) from dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH inner join dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHSYSTEMMESSAGES on UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHSYSTEMMESSAGES.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHID = UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHUSERMESSAGE.ID) from dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH inner join dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHUSERMESSAGE on UPDATEMULTIPLECONSTITUENTSFROMMFOBATCHBATCHUSERMESSAGE.ID = UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'a81a6bbf-d3cc-410b-8c15-cf63f9d160b2' begin -- Account Batch

select @count = count(GLACCOUNTBATCHBATCHSYSTEMMESSAGES.ID) from dbo.GLACCOUNTBATCH inner join dbo.GLACCOUNTBATCHBATCHSYSTEMMESSAGES on GLACCOUNTBATCHBATCHSYSTEMMESSAGES.GLACCOUNTBATCHID = GLACCOUNTBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(GLACCOUNTBATCHBATCHUSERMESSAGE.ID) from dbo.GLACCOUNTBATCH inner join dbo.GLACCOUNTBATCHBATCHUSERMESSAGE on GLACCOUNTBATCHBATCHUSERMESSAGE.ID = GLACCOUNTBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'a955f961-d9f6-42f6-87e5-d012098eeacb' begin -- Account Segment Mapping Batch

select @count = count(BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES.ID) from dbo.BATCHPDACCOUNTSEGMENTMAPPING inner join dbo.BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES on BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES.BATCHPDACCOUNTSEGMENTMAPPINGID = BATCHPDACCOUNTSEGMENTMAPPING.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE.ID) from dbo.BATCHPDACCOUNTSEGMENTMAPPING inner join dbo.BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE on BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE.ID = BATCHPDACCOUNTSEGMENTMAPPING.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '326c43a6-d162-4fd4-8d61-fef9a0ee8c5e' begin -- Enhanced Revenue Batch

select @count = count(BATCHREVENUEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHREVENUE inner join dbo.BATCHREVENUEBATCHSYSTEMMESSAGES on BATCHREVENUEBATCHSYSTEMMESSAGES.BATCHREVENUEID = BATCHREVENUE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHREVENUEBATCHUSERMESSAGE.ID) from dbo.BATCHREVENUE inner join dbo.BATCHREVENUEBATCHUSERMESSAGE on BATCHREVENUEBATCHUSERMESSAGE.ID = BATCHREVENUE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '81a4a967-0e75-4ff2-876f-aea5c52fc2bc' begin -- Event Batch

select @count = count(BATCHEVENTBATCHSYSTEMMESSAGES.ID) from dbo.BATCHEVENT inner join dbo.BATCHEVENTBATCHSYSTEMMESSAGES on BATCHEVENTBATCHSYSTEMMESSAGES.BATCHEVENTID = BATCHEVENT.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHEVENTBATCHUSERMESSAGE.ID) from dbo.BATCHEVENT inner join dbo.BATCHEVENTBATCHUSERMESSAGE on BATCHEVENTBATCHUSERMESSAGE.ID = BATCHEVENT.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '49d9f33d-eac1-484c-ab36-e0e80e5ff085' begin -- Sponsor Batch

select @count = count(BATCHSPONSORSHIPBATCHSYSTEMMESSAGES.ID) from dbo.BATCHSPONSORSHIP inner join dbo.BATCHSPONSORSHIPBATCHSYSTEMMESSAGES on BATCHSPONSORSHIPBATCHSYSTEMMESSAGES.BATCHSPONSORSHIPID = BATCHSPONSORSHIP.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHSPONSORSHIPBATCHUSERMESSAGE.ID) from dbo.BATCHSPONSORSHIP inner join dbo.BATCHSPONSORSHIPBATCHUSERMESSAGE on BATCHSPONSORSHIPBATCHUSERMESSAGE.ID = BATCHSPONSORSHIP.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'fab0cefd-8452-497d-ba0e-3610f42d9119' begin -- Event Registrant Batch

select @count = count(BATCHEVENTREGISTRANTBATCHSYSTEMMESSAGES.ID) from dbo.BATCHEVENTREGISTRANT inner join dbo.BATCHEVENTREGISTRANTBATCHSYSTEMMESSAGES on BATCHEVENTREGISTRANTBATCHSYSTEMMESSAGES.BATCHEVENTREGISTRANTID = BATCHEVENTREGISTRANT.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHEVENTREGISTRANTBATCHUSERMESSAGE.ID) from dbo.BATCHEVENTREGISTRANT inner join dbo.BATCHEVENTREGISTRANTBATCHUSERMESSAGE on BATCHEVENTREGISTRANTBATCHUSERMESSAGE.ID = BATCHEVENTREGISTRANT.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '54ab2279-0b16-41a4-b7ba-f5aff5a926f8' begin -- Membership Batch

select @count = count(BATCHMEMBERSHIPBATCHSYSTEMMESSAGES.ID) from dbo.BATCHMEMBERSHIP inner join dbo.BATCHMEMBERSHIPBATCHSYSTEMMESSAGES on BATCHMEMBERSHIPBATCHSYSTEMMESSAGES.BATCHMEMBERSHIPID = BATCHMEMBERSHIP.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHMEMBERSHIPBATCHUSERMESSAGE.ID) from dbo.BATCHMEMBERSHIP inner join dbo.BATCHMEMBERSHIPBATCHUSERMESSAGE on BATCHMEMBERSHIPBATCHUSERMESSAGE.ID = BATCHMEMBERSHIP.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '7df5523a-8c9a-4a6a-a273-397525b6b70d' begin -- Interaction Batch

select @count = count(BATCHINTERACTIONBATCHSYSTEMMESSAGES.ID) from dbo.BATCHINTERACTION inner join dbo.BATCHINTERACTIONBATCHSYSTEMMESSAGES on BATCHINTERACTIONBATCHSYSTEMMESSAGES.BATCHINTERACTIONID = BATCHINTERACTION.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHINTERACTIONBATCHUSERMESSAGE.ID) from dbo.BATCHINTERACTION inner join dbo.BATCHINTERACTIONBATCHUSERMESSAGE on BATCHINTERACTIONBATCHUSERMESSAGE.ID = BATCHINTERACTION.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'df0f31dd-eecd-4688-8b56-1dce8051e967' begin -- EmailFinder Batch

select @count = count(BATCHEMAILFINDERBATCHSYSTEMMESSAGES.ID) from dbo.BATCHEMAILFINDER inner join dbo.BATCHEMAILFINDERBATCHSYSTEMMESSAGES on BATCHEMAILFINDERBATCHSYSTEMMESSAGES.BATCHEMAILFINDERID = BATCHEMAILFINDER.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHEMAILFINDERBATCHUSERMESSAGE.ID) from dbo.BATCHEMAILFINDER inner join dbo.BATCHEMAILFINDERBATCHUSERMESSAGE on BATCHEMAILFINDERBATCHUSERMESSAGE.ID = BATCHEMAILFINDER.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '55553a7a-c66e-498d-9257-621951b44c1a' begin -- Registrant Batch

select @count = count(REGISTRANTBATCHBATCHSYSTEMMESSAGES.ID) from dbo.REGISTRANTBATCH inner join dbo.REGISTRANTBATCHBATCHSYSTEMMESSAGES on REGISTRANTBATCHBATCHSYSTEMMESSAGES.REGISTRANTBATCHID = REGISTRANTBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(REGISTRANTBATCHBATCHUSERMESSAGE.ID) from dbo.REGISTRANTBATCH inner join dbo.REGISTRANTBATCHBATCHUSERMESSAGE on REGISTRANTBATCHBATCHUSERMESSAGE.ID = REGISTRANTBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'c2952bbd-e65b-4e33-be21-db4defaf96df' begin -- PeopleFinder Batch

select @count = count(BATCHPEOPLEFINDERBATCHSYSTEMMESSAGES.ID) from dbo.BATCHPEOPLEFINDER inner join dbo.BATCHPEOPLEFINDERBATCHSYSTEMMESSAGES on BATCHPEOPLEFINDERBATCHSYSTEMMESSAGES.BATCHPEOPLEFINDERID = BATCHPEOPLEFINDER.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHPEOPLEFINDERBATCHUSERMESSAGE.ID) from dbo.BATCHPEOPLEFINDER inner join dbo.BATCHPEOPLEFINDERBATCHUSERMESSAGE on BATCHPEOPLEFINDERBATCHUSERMESSAGE.ID = BATCHPEOPLEFINDER.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '6abf3e1e-25e3-4429-91b2-9496c3dda413' begin -- PhoneFinder Batch

select @count = count(BATCHPHONEFINDERBATCHSYSTEMMESSAGES.ID) from dbo.BATCHPHONEFINDER inner join dbo.BATCHPHONEFINDERBATCHSYSTEMMESSAGES on BATCHPHONEFINDERBATCHSYSTEMMESSAGES.BATCHPHONEFINDERID = BATCHPHONEFINDER.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHPHONEFINDERBATCHUSERMESSAGE.ID) from dbo.BATCHPHONEFINDER inner join dbo.BATCHPHONEFINDERBATCHUSERMESSAGE on BATCHPHONEFINDERBATCHUSERMESSAGE.ID = BATCHPHONEFINDER.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'd85e7dc8-61dc-4f96-a7f5-2fe427fce6ed' begin -- Direct Marketing Effort Batch

select @count = count(BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGES.ID) from dbo.BATCHDIRECTMARKETINGEFFORT inner join dbo.BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGES on BATCHDIRECTMARKETINGEFFORTBATCHSYSTEMMESSAGES.BATCHDIRECTMARKETINGEFFORTID = BATCHDIRECTMARKETINGEFFORT.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHDIRECTMARKETINGEFFORTBATCHUSERMESSAGE.ID) from dbo.BATCHDIRECTMARKETINGEFFORT inner join dbo.BATCHDIRECTMARKETINGEFFORTBATCHUSERMESSAGE on BATCHDIRECTMARKETINGEFFORTBATCHUSERMESSAGE.ID = BATCHDIRECTMARKETINGEFFORT.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'e8c7be97-e1a5-4c88-a991-a703df433614' begin -- Currency Exchange Rate Batch

select @count = count(BATCHCURRENCYEXCHANGERATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHCURRENCYEXCHANGERATE inner join dbo.BATCHCURRENCYEXCHANGERATEBATCHSYSTEMMESSAGES on BATCHCURRENCYEXCHANGERATEBATCHSYSTEMMESSAGES.BATCHCURRENCYEXCHANGERATEID = BATCHCURRENCYEXCHANGERATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHCURRENCYEXCHANGERATEBATCHUSERMESSAGE.ID) from dbo.BATCHCURRENCYEXCHANGERATE inner join dbo.BATCHCURRENCYEXCHANGERATEBATCHUSERMESSAGE on BATCHCURRENCYEXCHANGERATEBATCHUSERMESSAGE.ID = BATCHCURRENCYEXCHANGERATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '6ded1db2-4dc0-4761-bc7c-4d79148f101e' begin -- Account by Account System Batch

select @count = count(GLACCOUNTBATCHBATCHSYSTEMMESSAGES.ID) from dbo.GLACCOUNTBATCH inner join dbo.GLACCOUNTBATCHBATCHSYSTEMMESSAGES on GLACCOUNTBATCHBATCHSYSTEMMESSAGES.GLACCOUNTBATCHID = GLACCOUNTBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(GLACCOUNTBATCHBATCHUSERMESSAGE.ID) from dbo.GLACCOUNTBATCH inner join dbo.GLACCOUNTBATCHBATCHUSERMESSAGE on GLACCOUNTBATCHBATCHUSERMESSAGE.ID = GLACCOUNTBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'a72b21ab-da2c-4bf4-9ff2-99799421776b' begin -- Account Segment Mapping by Account System Batch

select @count = count(BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES.ID) from dbo.BATCHPDACCOUNTSEGMENTMAPPING inner join dbo.BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES on BATCHPDACCOUNTSEGMENTMAPPINGBATCHSYSTEMMESSAGES.BATCHPDACCOUNTSEGMENTMAPPINGID = BATCHPDACCOUNTSEGMENTMAPPING.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE.ID) from dbo.BATCHPDACCOUNTSEGMENTMAPPING inner join dbo.BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE on BATCHPDACCOUNTSEGMENTMAPPINGBATCHUSERMESSAGE.ID = BATCHPDACCOUNTSEGMENTMAPPING.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '762eacc2-4e39-4118-ade1-f8413db213ab' begin -- Auction Item Batch

select @count = count(BATCHAUCTIONITEMBATCHSYSTEMMESSAGES.ID) from dbo.BATCHAUCTIONITEM inner join dbo.BATCHAUCTIONITEMBATCHSYSTEMMESSAGES on BATCHAUCTIONITEMBATCHSYSTEMMESSAGES.BATCHAUCTIONITEMID = BATCHAUCTIONITEM.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHAUCTIONITEMBATCHUSERMESSAGE.ID) from dbo.BATCHAUCTIONITEM inner join dbo.BATCHAUCTIONITEMBATCHUSERMESSAGE on BATCHAUCTIONITEMBATCHUSERMESSAGE.ID = BATCHAUCTIONITEM.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'ee9c5694-ee80-4b3d-8c0f-baf562251b07' begin -- AuctionMaestro Pro Import Batch

select @count = count(BATCHAMPROIMPORTBATCHSYSTEMMESSAGES.ID) from dbo.BATCHAMPROIMPORT inner join dbo.BATCHAMPROIMPORTBATCHSYSTEMMESSAGES on BATCHAMPROIMPORTBATCHSYSTEMMESSAGES.BATCHAMPROIMPORTID = BATCHAMPROIMPORT.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHAMPROIMPORTBATCHUSERMESSAGE.ID) from dbo.BATCHAMPROIMPORT inner join dbo.BATCHAMPROIMPORTBATCHUSERMESSAGE on BATCHAMPROIMPORTBATCHUSERMESSAGE.ID = BATCHAMPROIMPORT.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'e923f2a0-e76d-43c2-8f4a-795c6c0d679f' begin -- Revenue Update Batch

select @count = count(BATCHREVENUEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHREVENUE inner join dbo.BATCHREVENUEBATCHSYSTEMMESSAGES on BATCHREVENUEBATCHSYSTEMMESSAGES.BATCHREVENUEID = BATCHREVENUE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHREVENUEBATCHUSERMESSAGE.ID) from dbo.BATCHREVENUE inner join dbo.BATCHREVENUEBATCHUSERMESSAGE on BATCHREVENUEBATCHUSERMESSAGE.ID = BATCHREVENUE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '17b315e1-f5a7-48c0-96a8-c9af96247b03' begin -- Event Sponsorship Batch

select @count = count(BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGES.ID) from dbo.BATCHEVENTSPONSORSHIP inner join dbo.BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGES on BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGES.BATCHEVENTSPONSORSHIPID = BATCHEVENTSPONSORSHIP.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHEVENTSPONSORSHIPBATCHUSERMESSAGE.ID) from dbo.BATCHEVENTSPONSORSHIP inner join dbo.BATCHEVENTSPONSORSHIPBATCHUSERMESSAGE on BATCHEVENTSPONSORSHIPBATCHUSERMESSAGE.ID = BATCHEVENTSPONSORSHIP.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '3c43e751-4b2f-4c59-89a7-68af42bdae91' begin -- Donation Batch

select @count = count(DONATIONBATCHBATCHSYSTEMMESSAGES.ID) from dbo.DONATIONBATCH inner join dbo.DONATIONBATCHBATCHSYSTEMMESSAGES on DONATIONBATCHBATCHSYSTEMMESSAGES.DONATIONBATCHID = DONATIONBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(DONATIONBATCHBATCHUSERMESSAGE.ID) from dbo.DONATIONBATCH inner join dbo.DONATIONBATCHBATCHUSERMESSAGE on DONATIONBATCHBATCHUSERMESSAGE.ID = DONATIONBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '39a0c63a-a774-443e-82a7-ffd197cff2c0' begin -- Stewardship Plan Step Update Batch

select @count = count(BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGES.ID) from dbo.BATCHSTEWARDSHIPPLANSTEPUPDATE inner join dbo.BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGES on BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHSYSTEMMESSAGES.BATCHSTEWARDSHIPPLANSTEPUPDATEID = BATCHSTEWARDSHIPPLANSTEPUPDATE.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHUSERMESSAGE.ID) from dbo.BATCHSTEWARDSHIPPLANSTEPUPDATE inner join dbo.BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHUSERMESSAGE on BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHUSERMESSAGE.ID = BATCHSTEWARDSHIPPLANSTEPUPDATE.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = 'eb45e5af-d6c2-428c-a9c9-7af321466a99' begin -- FAF Event Batch

select @count = count(FAFEVENTBATCHBATCHSYSTEMMESSAGES.ID) from dbo.FAFEVENTBATCH inner join dbo.FAFEVENTBATCHBATCHSYSTEMMESSAGES on FAFEVENTBATCHBATCHSYSTEMMESSAGES.FAFEVENTBATCHID = FAFEVENTBATCH.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(FAFEVENTBATCHBATCHUSERMESSAGE.ID) from dbo.FAFEVENTBATCH inner join dbo.FAFEVENTBATCHBATCHUSERMESSAGE on FAFEVENTBATCHBATCHUSERMESSAGE.ID = FAFEVENTBATCH.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '196a2540-005a-4547-91a7-b301c464e28c' begin -- Membership Dues Batch

select @count = count(BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGES.ID) from dbo.BATCHMEMBERSHIPDUES inner join dbo.BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGES on BATCHMEMBERSHIPDUESBATCHSYSTEMMESSAGES.BATCHMEMBERSHIPDUESID = BATCHMEMBERSHIPDUES.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHMEMBERSHIPDUESBATCHUSERMESSAGE.ID) from dbo.BATCHMEMBERSHIPDUES inner join dbo.BATCHMEMBERSHIPDUESBATCHUSERMESSAGE on BATCHMEMBERSHIPDUESBATCHUSERMESSAGE.ID = BATCHMEMBERSHIPDUES.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '4ff8136d-6464-4f13-bb29-6c300ef6df26' begin -- Pledge Write-off Batch

select @count = count(BATCHPLEDGEWRITEOFFBATCHSYSTEMMESSAGES.ID) from dbo.BATCHPLEDGEWRITEOFF inner join dbo.BATCHPLEDGEWRITEOFFBATCHSYSTEMMESSAGES on BATCHPLEDGEWRITEOFFBATCHSYSTEMMESSAGES.BATCHPLEDGEWRITEOFFID = BATCHPLEDGEWRITEOFF.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHPLEDGEWRITEOFFBATCHUSERMESSAGE.ID) from dbo.BATCHPLEDGEWRITEOFF inner join dbo.BATCHPLEDGEWRITEOFFBATCHUSERMESSAGE on BATCHPLEDGEWRITEOFFBATCHUSERMESSAGE.ID = BATCHPLEDGEWRITEOFF.ID where BATCHID = @BATCHID;
end
end

 else if @BATCHTYPECATALOGID = '54955e1c-ab7b-485b-bdd9-aa36d26a9821' begin -- Merchandise Inventory Batch

select @count = count(BATCHMERCHANDISEINVENTORYBATCHSYSTEMMESSAGES.ID) from dbo.BATCHMERCHANDISEINVENTORY inner join dbo.BATCHMERCHANDISEINVENTORYBATCHSYSTEMMESSAGES on BATCHMERCHANDISEINVENTORYBATCHSYSTEMMESSAGES.BATCHMERCHANDISEINVENTORYID = BATCHMERCHANDISEINVENTORY.ID where BATCHID = @BATCHID;

if @count = 0 begin
select @count = count(BATCHMERCHANDISEINVENTORYBATCHUSERMESSAGE.ID) from dbo.BATCHMERCHANDISEINVENTORY inner join dbo.BATCHMERCHANDISEINVENTORYBATCHUSERMESSAGE on BATCHMERCHANDISEINVENTORYBATCHUSERMESSAGE.ID = BATCHMERCHANDISEINVENTORY.ID where BATCHID = @BATCHID;
end
end



    if @COUNT > 0 begin
        return 1
    end

    return 0
end