update #Request.prefix_db_agency#.pSchedules set ApproveBill = '1' where Schedule_ID in (#chkvalue#) update #Request.prefix_db_agency#.pSchedules set ApproveBill = '0' where Schedule_ID in (#unchkvalue#) update #Request.prefix_db_agency#.pSchedules set Status = '1' where Schedule_ID in(#Schedule_ID#) update #Request.prefix_db_agency#.pSchedules set NOA = '1' where Schedule_ID in(#Schedule_ID#) AND status = 0