update HrmSalarypaydetail set status = 0
where payid in (select id from HrmSalaryPay where paydate = ‘2018-12’) – 这里填写要打开的月份 and departmentid in (select id from Hrmdepartment where subcompanyid1 in(分部的ID))
泛微ecology 工资薪酬 工资单重新打开sql
最新推荐文章于 2024-03-15 10:47:46 发布