Hello Rod,
many thank’s for your answer.
This is the code of the Stored procedure that generate the problem.
/****** Object: User-Defined Data Type [dbo].[T_Data] Script Date: 18/08/2016 23:15:12 ******/
CREATE TYPE [dbo].[T_Data] FROM smalldatetime NOT NULL;
GO
/****** Object: User-Defined Data Type [dbo].[T_Conta] Script Date: 18/08/2016 23:15:13 ******/
CREATE TYPE [dbo].[T_Conta] FROM decimal(3, 0) NOT NULL;
GO
/****** Object: User-Defined Data Type [dbo].[T_Secondi] Script Date: 18/08/2016 23:15:13 ******/
CREATE TYPE [dbo].[T_Secondi] FROM bigint NOT NULL;
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE PROCEDURE [dbo].[SpRiskedula]
@DataInizio [dbo].[T_Data], @NumeroGiorniLavest [dbo].[T_Conta] = 5, @Recupero [dbo].[T_Secondi] = 7200
WITH EXEC AS CALLER
AS
UPDATE SkMacchine
SET Datadisp = @DataInizio
UPDATE SkOperazioni
SET Nrmacc = 0, Estratto = ’ ', Priorita = 0.0, Inizio = @DataInizio, InizioLav = NULL, Fine = NULL, Attesa = 0, Fermo = 0,
Recupero = 0
UPDATE SkOperazioni
SET estratto = ‘1’
WHERE sequenza = 1
UPDATE Skoperazioni
SET secondi = (SELECT 3 * 28800 * @NumeroGiorniLavest
FROM SkMacchine
WHERE Skoperazioni.Cdmacc = SkMacchine.cdmacc AND SkMacchine.NrMacc = 1)
WHERE CDREP = ‘ES’
UPDATE Skoperazioni
SET afinire = (SELECT sum(secondi)
FROM Skoperazioni B
WHERE Skoperazioni.Cdcommessa = B.cdcommessa AND Skoperazioni.sequenza <= B.sequenza)
EXECUTE dbo.SpRecupero @tempo = @Recupero
UPDATE skoperazioni
SET PrioritaRCommessa = (SELECT PrioritaCommessa
FROM skCommesse
WHERE CdCommessa = commessa)
EXECUTE dbo.spPrioritaComava0
GO
When I select debug - I obtain the GPF , without do nothing.
Best regards,
Sergio