To select and delete gift group batches: --Delete gift group select * from dbo.GIFT_GROUP_CTRL where GIFT_GROUP_NUM in ( 3580) delete FROM GIFT_GROUP_CTRL where GIFT_GROUP_NUM = 3580 select * from gift_master where GIFT_GROUP_NUM = 3580 select * from GIFT_TRAN where GIFT_GROUP_NUM = 3580 The group number in the ticket should replace the one in the scripts. Typically I have only had to delete from the gift_group_ctl table but the selects on gift_master and gift_tran should be run to be sure those tables are empty first. If they are not, then it involves a conversation with IA to see if they can delete the data using Jenzabar.