DELETE FROM [PrintJobQueue] WHERE (([IdxPrintJob] = @Original_IdxPrintJob) AND ([TipoReport] = @Original_TipoReport) AND ([KeyParam] = @Original_KeyParam) AND ([prtName] = @Original_prtName) AND ([dtStart] = @Original_dtStart) AND ((@IsNull_dtEnd = 1 AND [dtEnd] IS NULL) OR ([dtEnd] = @Original_dtEnd)) AND ([stato] = @Original_stato) AND ((@IsNull_dtLastTry = 1 AND [dtLastTry] IS NULL) OR ([dtLastTry] = @Original_dtLastTry))) INSERT INTO [PrintJobQueue] ([printerQueue], [keyParam], [dtStart], [dtEnd], [stato], [dtLastTry]) VALUES (@printerQueue, @keyParam, @dtStart, @dtEnd, @stato, @dtLastTry); SELECT IdxPrintJob, printerQueue, keyParam, dtStart, dtEnd, stato, dtLastTry FROM PrintJobQueue WHERE (IdxPrintJob = SCOPE_IDENTITY()) SELECT * FROM PrintJobQueue UPDATE [PrintJobQueue] SET [TipoReport] = @TipoReport, [KeyParam] = @KeyParam, [prtName] = @prtName, [dtStart] = @dtStart, [dtEnd] = @dtEnd, [stato] = @stato, [dtLastTry] = @dtLastTry WHERE (([IdxPrintJob] = @Original_IdxPrintJob) AND ([TipoReport] = @Original_TipoReport) AND ([KeyParam] = @Original_KeyParam) AND ([prtName] = @Original_prtName) AND ([dtStart] = @Original_dtStart) AND ((@IsNull_dtEnd = 1 AND [dtEnd] IS NULL) OR ([dtEnd] = @Original_dtEnd)) AND ([stato] = @Original_stato) AND ((@IsNull_dtLastTry = 1 AND [dtLastTry] IS NULL) OR ([dtLastTry] = @Original_dtLastTry))); SELECT IdxPrintJob, TipoReport, KeyParam, prtName, dtStart, dtEnd, stato, dtLastTry FROM PrintJobQueue WHERE (IdxPrintJob = @IdxPrintJob) dbo.stp_PJQ_chiudiZoombie dbo.stp_PJQ_getByQueue dbo.stp_PJQ_getByQueueAll dbo.stp_PJQ_getFirtsByParam dbo.stp_PJQ_getNext dbo.stp_PJQ_getWaiting dbo.stp_PJQ_insert dbo.stp_PJQ_updateLastTry dbo.stp_PJQ_updateStato dbo.stp_prt_CartellinoFinitiOdette dbo.stp_prt_CartellinoPedane dbo.stp_prt_CartellinoSemilavorati rep.stp_prt_ReportPackList rep.stp_prt_ReportPackListFull