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