USE [thd_sms_8746]
GO
/ Object: StoredProcedure [dbo].[spTranFile] Script Date: 22/11/2022 01:56:51 p. m. /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Ron Cox
-- Create date: 10/17/12
-- Description: Stored procedure for TranFile(pdbupd)
-- Key is TranDate,Pdbupd,Sequence,EOP
--Find where pdbupd = no and(errorintran = no or eop = yes)
-- =============================================
ALTER PROCEDURE [dbo].[spTranFile] @TranDate DATETIME = NULL
AS
SET NOCOUNT ON;
EXEC dbo.WriteSystemLog 4,N'spTranFile',-1,'L3 pruebas'
SELECT EOP AS EOP
, ErrorInTran AS ErrorInTran
, Pdbupd AS Pdbupd
, RegisterID AS RegisterID
, [Sequence] AS Sequence
, TranDate AS TranDate
, TranNumber AS TranNumber
FROM TranFile
WHERE (
------ @TranDate IS NULL
------ OR TranDate = @TranDate
--------SDLR ROLLBACK
------OR
Trandate = '2022-11-21' --Hack para postear dia previo. NACG 2022-06-29
)
AND Pdbupd = 0
AND (
ErrorInTran = 0
OR EOP = 1
)
OPTION (RECOMPILE); 