CREATE PROCEDURE sp_BancosActualizarFromERP
 AS
 DECLARE @Cantidad INT
 DECLARE @Bancos AS  TABLE  (  [BanID] INT   NOT NULL ,  [BanNombre] VARCHAR(100)   NULL ,  [BanReferencia] VARCHAR(10)   NULL ,  [UsuInicioSesion] VARCHAR(64)   NULL ,  [BanFechaActualizacion] VARCHAR(50)   NULL ,  [rowguid] uniqueidentifier   NOT NULL ,  [BanTipo] VARCHAR(50)   NULL ,  PRIMARY KEY (   [BanID]  ), UNIQUE NONCLUSTERED ([rowguid])  )
 INSERT INTO @Bancos( [BanID], [BanNombre], [BanReferencia], [UsuInicioSesion], [BanFechaActualizacion], [rowguid], [BanTipo])
 SELECT   AS [BanID],
 AS [BanNombre],
 AS [BanReferencia],
 AS [UsuInicioSesion],
 AS [BanFechaActualizacion],
 AS [rowguid],
 AS [BanTipo]
 FROM Bancos
 WHERE 1=1

 SELECT @Cantidad = COUNT(*) FROM  @Bancos

 IF @Cantidad = 0
 RETURN

UPDATE @Bancos
SET
 rowguid = B.rowguid
FROM @Bancos A,Bancos B
WHERE
 A.BanID = B.BanID  AND
 (
A.rowguid <>  B.rowguid  )

 DELETE FROM  Bancos
 WHERE rowguid NOT IN (SELECT rowguid FROM @Bancos)


 INSERT INTO Bancos ( BanID, BanNombre, BanReferencia, UsuInicioSesion, BanFechaActualizacion, rowguid, BanTipo)
 SELECT BanID, BanNombre, BanReferencia, UsuInicioSesion, BanFechaActualizacion, rowguid, BanTipo
FROM @Bancos A
WHERE A.rowguid NOT IN  (
 SELECT  Bancos.rowguid FROM Bancos )


UPDATE Bancos
SET
 BanID = B.BanID,
 BanNombre = B.BanNombre,
 BanReferencia = B.BanReferencia,
 UsuInicioSesion = B.UsuInicioSesion,
 BanFechaActualizacion = B.BanFechaActualizacion,
 BanTipo = B.BanTipo
FROM Bancos A,@Bancos B
WHERE  A.ROWGUID = B.ROWGUID AND
 (
A.BanID <>  B.BanID OR
A.BanNombre <>  B.BanNombre OR
A.BanReferencia <>  B.BanReferencia OR
A.UsuInicioSesion <>  B.UsuInicioSesion OR
A.BanTipo <>  B.BanTipo  )