ALTER PROCEDURE dbo.spINCONSISTENCIA_Hipotecario_Alta_Count
@IdInconsistencia BIGINT
AS

DELETE FROM dbo.MIGRACION_InconsistenciaResumen WHERE IdInconsistencia = @IdInconsistencia
---------------------------------------------------------------------------
DECLARE @count INT
SELECT @count = COUNT(*)
FROM dbo.INCONSISTENCIA_VW_Hipotecario vw
WHERE vw.IdTipoAlta NOT IN (
	SELECT IdTipoAlta FROM dbo.SICC_TipoAlta
) OR vw.IdTipoAlta IS NULL
---------------------------------------------------------------------------

INSERT INTO dbo.MIGRACION_InconsistenciaResumen ( IdInconsistencia, Numero, Fecha )
VALUES(@IdInconsistencia, @count,GETDATE())

SELECT @count

GO

CREATE PROCEDURE spINCONSISTENCIA_Hipotecario_Alta
AS

SELECT vw.Codigo, vw.CodigoTipoAlta
FROM dbo.INCONSISTENCIA_VW_Hipotecario vw
WHERE vw.IdTipoAlta NOT IN (
	SELECT IdTipoAlta FROM dbo.SICC_TipoAlta
) OR vw.IdTipoAlta IS NULL

GO