-----------dejar
sin efecto el primary key INSERT INTO
SELECT AÑADIR DATOS A TABLA-------------------------------
SET IDENTITY_INSERT CONELEC..USERINFO ON
INSERT INTO CONELEC..USERINFO
select S.* from SirhaTime..USERINFO S
where S.BADGENUMBER NOT IN (select C.BADGENUMBER from CONELEC..USERINFO C) ORDER BY BADGENUMBER ASC
SET IDENTITY_INSERT CONELEC..USERINFO OFF
-----------TABLA
TEMPORAL CTE COMMON TABLE EXPRESION -------------------------------
with allabound
as
(
select S.* from SirhaTime..USERINFO S where S.BADGENUMBER
NOT IN (select C.BADGENUMBER from CONELEC..USERINFO C) --ORDER BY BADGENUMBER
ASC
)
INSERT INTO CONELEC..USERINFO
SELECT
SELECT
[BADGENUMBER]
,[SSN]
,[NAME]
,[GENDER]
,[TITLE]
,[PAGER]
,[BIRTHDAY]
,[HIREDDAY]
,[STREET]
,[CITY]
,[STATE]
,[ZIP]
,[OPHONE]
,[FPHONE]
,[VERIFICATIONMETHOD]
,[DEFAULTDEPTID]
,[SECURITYFLAGS]
,[ATT]
,[INLATE]
,[OUTEARLY]
,[OVERTIME]
,[SEP]
,[HOLIDAY]
,[MINZU]
,[PASSWORD]
,[LUNCHDURATION]
,[MVerifyPass]
,[PHOTO]
,[Notes]
,[privilege]
,[InheritDeptSch]
,[InheritDeptSchClass]
,[AutoSchPlan]
,[MinAutoSchInterval]
,[RegisterOT]
,[InheritDeptRule]
,[EMPRIVILEGE]
,[CardNo]
,[OTAdmin]
,[OTPass]
,[OTPrivAdmin]
,[Pin1]
,[OpcionEmpleado]
,[SIRHAPASS]
,[EMAIL]
,[CHECKONLINE]
,[CHECKEMAIL]
,[Genero]
,[EstadoCivil]
,[LugarTrabajo]
,[Cargo]
,[TipoContrato]
,[FechaRenuncia]
,[Discapacidad]
,[CargasFamiliares]
,[TipoSangre]
,[TelCasa]
,[TelCel]
,[NombreContacto]
,[TelContacto]
,[Observacion]
,[Firma]
,[CHECKORDER]
,[Tvacacion]
,[MEN_USU]
,[POR_USU]
,[PRO_USU]
,[PRI_USU]
,[Svacacion]
,[Adicional]
FROM allabound
No hay comentarios:
Publicar un comentario