ERP-PS每月定时更新临时KCCKYE

drop table KCCKYE_NJ_LS

SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
KCCKYE_SLYE,KCCKYE_FSLYE1,KCCKYE_FSLYE2,KCCKYE_JEYE into KCCKYE_NJ_LS FROM KCCKYE WITH (nolock)
WHERE ( KCCKYE_SLYE>0   OR  KCCKYE_SLYE<0) AND KCCKYE_KJND+KCCKYE_KJQJ=(SELECT MAX(KCCKYE_KJND+KCCKYE_KJQJ) FROM KCCKYE (nolock))

SELECT  * FROM  KCCKYE_NJ_LS