21 lines
858 B
Plaintext
21 lines
858 B
Plaintext
--取得客戶專案、年度專案編號、派遣人員編號的關係
|
|
|
|
SELECT A.BPPNM, B.BPPYN, C.RANUM
|
|
FROM BPRJ A
|
|
INNER JOIN BPAA B ON A.BPPNM=B.BPPNM
|
|
INNER JOIN RASN C ON B.BPPYN=C.RAPYN
|
|
WHERE B.BPYER=97
|
|
|
|
|
|
-- 查 加班 累積補休
|
|
select RPREN AS 加班單號, RPRDT AS 日期, RPRTM AS 開始時間, RPETM AS 結束時間, RPDOC 備註, RPTCT 時數, RPUST 已沖
|
|
from RPAR WHERE RPTYP='11' AND RPNUM='00989'
|
|
|
|
-- 查 請假 補休
|
|
select RPREN AS 請假單號, RPRDT AS 日期, RPRTM AS 開始時間, RPETM AS 結束時間, RPDOC 備註, RPTCT 時數, RPUST 已沖
|
|
from RPAR WHERE RPTYP='00' AND RPNUM='00989'
|
|
|
|
-- 查 沖補休
|
|
SELECT RPREN AS 請假單號, RPREX AS 加班單號, RPTCT AS 沖銷時數 FROM RPAC WHERE RPREN= '2012061090'
|
|
SELECT RPREN AS 請假單號, RPREX AS 加班單號, RPTCT AS 沖銷時數 FROM RPAC WHERE RPREN= '2012071108'
|
|
SELECT RPREN AS 請假單號, RPREX AS 加班單號, RPTCT AS 沖銷時數 FROM RPAC WHERE RPREN= '2012071235' |