ALTER TABLE VS4TEmployee2 ADD
	TEm2ExceptTimeIn smallint NULL,
	TEm2ExceptTimeOut smallint NULL,
	TEm2ExceptOT smallint NULL,
	TEm2ExceptTip smallint NULL,
	TEm2ExceptOTin smallint NULL,
	TEm2ExceptOTOut smallint NULL,
	TEm2ExceptLunchIn smallint NULL,
	TEm2ExceptLunchOut smallint NULL,
	TEm2FullOTCheck smallint NULL,
	TEm2DeductLoss smallint NULL,
	TEm2DeductLeave smallint NULL,
	TEm2DeductLate smallint NULL,
	TEm2DeductEarly smallint NULL
GO

UPDATE VS4TEmployee2 set TEm2ExceptTimeIn=(SELECT TEmpExceptTimeIn  FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptTimeOut =(SELECT TEmpExceptTimeOut FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptOT =(SELECT TEmpExceptOT FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptTip =(SELECT TEmpExceptTip FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptOTin =(SELECT TEmpExceptOTin FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptOTOut =(SELECT TEmpExceptOTOut FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptLunchIn= (SELECT TEmpExceptLunchIn FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2ExceptLunchOut =(SELECT TEmpExceptLunchOut FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2FullOTCheck =(SELECT TEmpFullOTCheck FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2DeductLoss =(SELECT TEmpDeductLoss FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2DeductLeave= (SELECT TEmpDeductLeave FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2DeductLate= (SELECT TEmpDeductLate FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO
UPDATE VS4TEmployee2 set TEm2DeductEarly= (SELECT TEmpDeductEarly FROM VS4TEmployee Where TEmpCode=TEm2TEmpCode)
GO

ALTER TABLE VS4TEmployee
	DROP COLUMN TEmpExceptTimeIn,TEmpExceptTimeOut ,TEmpExceptOT ,TEmpExceptTip ,TEmpExceptOTin ,TEmpExceptOTOut ,TEmpExceptLunchIn ,TEmpExceptLunchOut ,TEmpFullOTCheck ,TEmpDeductLoss ,TEmpDeductLeave ,TEmpDeductLate ,TEmpDeductEarly 
GO



