CREATE PROC [dbo].[MOSTRAR]
@PAYSTATION INT,
@CONTROL INT,
@FECHA_IN DATE,
@FECHA_FIN DATE
AS
delete from Consulta
insert into Consulta
SELECT intBoardNumber AS [PAYSTATION],
COUNT(intReceiptNumber) AS [DATO_REAL],
MIN(intReceiptNumber) AS [DEL],
MAX(intReceiptNumber) AS [AL],
@CONTROL-COUNT(intReceiptNumber) AS [RESTANTE]
FROM dbo.trDPFEE WHERE dtExitDate BETWEEN @FECHA_IN AND @FECHA_FIN AND intBoardNumber = @PAYSTATION AND intReceiptNumber<>0
GROUP BY intBoardNumber
SELECT *FROM Consulta