spDelete_ClientMerchantAccounts

            CREATE PROCEDURE [dbo].[spDelete_ClientMerchantAccounts]
              (
                      @PKID        int,
                      @CurrentUsersID    int
              )
              AS
                  begin transaction
                  update ClientDonations set ClientDonations.MerchantAccount = null where ClientDonations.MerchantAccount = @PKID 
                update ClientEvents set ClientEvents.MerchantAccount = null where ClientEvents.MerchantAccount = @PKID 
                  update ClientMemberships set ClientMemberships.MerchantAccount = null where ClientMemberships.MerchantAccount = @PKID 
                  update ShoppingCartPart set ShoppingCartPart.MerchantAccountID = null where ShoppingCartPart.MerchantAccountID = @PKID 
                  delete from ClientMerchantAccounts  where [ID] = @PKID
                  commit