Difference between revisions of "PAYROLL"
| Line 29: | Line 29: | ||
UPDATE mypaydv.hst2015 SET hstpccd = '3' | UPDATE mypaydv.hst2015 SET hstpccd = '3' | ||
| + | |||
| + | '''Alphalist.txt''' | ||
| + | |||
| + | |||
| + | /*select employee*/ | ||
| + | SELECT * FROM mypaydb.`alphalist2316_2015` WHERE ( | ||
| + | EMPTINO NOT IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa) OR EMPNUMB NOT IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa)) | ||
| + | AND COCD = '1' | ||
| + | |||
| + | /*select included employees*/ | ||
| + | SELECT * FROM mypaydb.`alphalist2316_2015` WHERE ( | ||
| + | EMPTINO IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa) OR EMPNUMB IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa)) | ||
| + | AND COCD = '1' | ||
| + | |||
| + | /*select not included employees*/ | ||
| + | SELECT * FROM oa.alphalist2316_2015_sepa WHERE ( | ||
| + | EMPNUMB NOT IN (SELECT EMPTINO FROM mypaydb.alphalist2316_2015) AND EMPNUMB NOT IN (SELECT EMPNUMB FROM mypaydb.alphalist2316_2015)) | ||
| + | GROUP BY empnumb | ||
| + | |||
| + | |||
| + | |||
| + | SELECT * FROM oa.`alphalist2316_2015_sepa` WHERE recid >= '1838' | ||
| + | |||
| + | SELECT * FROM mypaydb.alphalist2316_2015 WHERE cocd = '1' | ||
Revision as of 15:03, 16 June 2016
13th mo misc VIP.txt
SELECT * FROM mypaydb.hst2015
SELECT * FROM mypaydv.hst2015
SELECT * FROM mypaydv.hst2015 WHERE HSTNUMB IN(
SELECT HSTNUMB FROM mypaydb.hst2015
)
oa.hst2015_vip_b413mocomp
CREATE TABLE IF NOT EXISTS oa.hst2015_vip_b413mocomp_20151204 LIKE mypaydv.hst2015; INSERT INTO oa.hst2015_vip_b413mocomp_20151204 SELECT * FROM mypaydv.hst2015;
INSERT IGNORE INTO mypaydv.hst2015
SELECT * FROM mypaydb.hst2015 WHERE hstnumb IN(
SELECT HSTNUMB FROM mypaydv.hst2015
)
DELETE FROM mypaydb.hst2015 WHERE hstnumb IN(
SELECT HSTNUMB FROM mypaydv.hst2015
)
UPDATE mypaydv.hst2015 SET hstpccd = '3'
Alphalist.txt
/*select employee*/
SELECT * FROM mypaydb.`alphalist2316_2015` WHERE (
EMPTINO NOT IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa) OR EMPNUMB NOT IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa))
AND COCD = '1'
/*select included employees*/ SELECT * FROM mypaydb.`alphalist2316_2015` WHERE ( EMPTINO IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa) OR EMPNUMB IN (SELECT EMPNUMB FROM oa.alphalist2316_2015_sepa)) AND COCD = '1'
/*select not included employees*/ SELECT * FROM oa.alphalist2316_2015_sepa WHERE ( EMPNUMB NOT IN (SELECT EMPTINO FROM mypaydb.alphalist2316_2015) AND EMPNUMB NOT IN (SELECT EMPNUMB FROM mypaydb.alphalist2316_2015)) GROUP BY empnumb
SELECT * FROM oa.`alphalist2316_2015_sepa` WHERE recid >= '1838'
SELECT * FROM mypaydb.alphalist2316_2015 WHERE cocd = '1'
