If someone mistakenly marks a seat attended when stubs are being scanned, is there a way to fix that? We aren't set up yet for scanning tix when people enter the theater, so we have to manually do it with a handheld scanner when the show is over, and once in a while, errors are made.
Declare@TicketNo int = 162711Delete from T_ATTENDANCE where ticket_no = @TicketNo Delete from T_ORDER_SEAT_HIST where ticket_no = @TicketNo and event_code = 22