DELETE FROM [dbo].[TempiCicloRilevati] WHERE (([IdxMacchina] = @Original_IdxMacchina) AND ([CodArticolo] = @Original_CodArticolo) AND ([DataOraRif] = @Original_DataOraRif) AND ([TCMedio] = @Original_TCMedio) AND ([PzProd] = @Original_PzProd)) INSERT INTO [dbo].[TempiCicloRilevati] ([IdxMacchina], [CodArticolo], [DataOraRif], [TCMedio], [PzProd]) VALUES (@IdxMacchina, @CodArticolo, @DataOraRif, @TCMedio, @PzProd); SELECT IdxMacchina, CodArticolo, DataOraRif, TCMedio, PzProd FROM TempiCicloRilevati WHERE (CodArticolo = @CodArticolo) AND (DataOraRif = @DataOraRif) AND (IdxMacchina = @IdxMacchina) SELECT IdxMacchina, CodArticolo, DataOraRif, TCMedio, PzProd FROM dbo.TempiCicloRilevati UPDATE [dbo].[TempiCicloRilevati] SET [IdxMacchina] = @IdxMacchina, [CodArticolo] = @CodArticolo, [DataOraRif] = @DataOraRif, [TCMedio] = @TCMedio, [PzProd] = @PzProd WHERE (([IdxMacchina] = @Original_IdxMacchina) AND ([CodArticolo] = @Original_CodArticolo) AND ([DataOraRif] = @Original_DataOraRif) AND ([TCMedio] = @Original_TCMedio) AND ([PzProd] = @Original_PzProd)); SELECT IdxMacchina, CodArticolo, DataOraRif, TCMedio, PzProd FROM TempiCicloRilevati WHERE (CodArticolo = @CodArticolo) AND (DataOraRif = @DataOraRif) AND (IdxMacchina = @IdxMacchina) dbo.stp_TC_getByMacchinaPeriodo dbo.stp_TC_getByMacchinaPeriodoFiltMax dbo.stp_TC_getFilt dbo.stp_TC_getFiltCount dbo.stp_TC_getFiltPaged dbo.stp_TC_getDtLastPzByMacchinaQta dbo.stp_TC_getMaxByMacchinaPeriodo dbo.stp_TC_getMedByMacchinaPeriodo dbo.stp_TC_getMinByMacchinaPeriodo dbo.stp_TC_fixFromODL SELECT * FROM v_ODL_exp ORDER BY IdxODL DESC dbo.stp_ODL_approvaTC dbo.stp_ODL_AutoDayGener dbo.stp_ODL_AutoDayGenerFull dbo.stp_ODL_AutoStart dbo.stp_ODL_clearSetup dbo.stp_ODL_deleteQuery dbo.stp_ODL_dividiDaAltraTav dbo.stp_ODL_fineProd dbo.stp_ODL_fixMachineSlave dbo.stp_ODL_forceClose dbo.stp_ODL_getByCodArt dbo.stp_ODL_getByIdx dbo.stp_ODL_getByMacchina dbo.stp_ODL_getByMacchinaCodArt dbo.stp_ODL_getByMacchinaPeriodo dbo.stp_ODL_getByMacchinaPeriodoNoNull dbo.stp_ODL_getLastByMacchina dbo.stp_ODL_getLastByMacchinaNum dbo.stp_ODL_needAppr dbo.stp_ODL_inizioSetup dbo.stp_ODL_inizioSetupPromessa dbo.stp_ODL_inizioSetupPromessaPostuma dbo.stp_ODL_insertProvv dbo.stp_ODL_insertQuery dbo.stp_ODL_insPostumo dbo.stp_ODL_reopenOdlMacc dbo.stp_ODL_split dbo.stp_ODL_updateQta dbo.stp_ODL_update dbo.stp_ODL_updateSetup SELECT * FROM v_AnagArticoli dbo.stp_ART_checkUsed dbo.stp_ART_delete dbo.stp_ART_getById dbo.stp_ART_getByCurrPODL dbo.stp_ART_getByDescript dbo.stp_ART_getLastByMacch dbo.stp_ART_getPaged dbo.stp_ART_getUsed dbo.stp_ART_insert dbo.stp_ART_rowCount dbo.stp_ART_setNewRev dbo.stp_ART_update SELECT * FROM v_DatiMacchina_exp dbo.stp_DATM_getByIdx dbo.stp_DATM_update DELETE FROM [PostazioniMapo] WHERE (([IdxPostazione] = @Original_IdxPostazione) AND ((@IsNull_DescPostazione = 1 AND [DescPostazione] IS NULL) OR ([DescPostazione] = @Original_DescPostazione)) AND ([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_MatrOperatore = 1 AND [MatrOperatore] IS NULL) OR ([MatrOperatore] = @Original_MatrOperatore)) AND ((@IsNull_InputUntil = 1 AND [InputUntil] IS NULL) OR ([InputUntil] = @Original_InputUntil)) AND ((@IsNull_LastBarcode = 1 AND [LastBarcode] IS NULL) OR ([LastBarcode] = @Original_LastBarcode))) INSERT INTO [PostazioniMapo] ([IdxPostazione], [DescPostazione], [IdxMacchina], [MatrOperatore], [InputUntil], [LastBarcode]) VALUES (@IdxPostazione, @DescPostazione, @IdxMacchina, @MatrOperatore, @InputUntil, @LastBarcode); SELECT IdxPostazione, DescPostazione, IdxMacchina, MatrOperatore, InputUntil, LastBarcode FROM PostazioniMapo WHERE (IdxPostazione = @IdxPostazione) SELECT IdxPostazione, DescPostazione, IdxMacchina, MatrOperatore, InputUntil, LastBarcode FROM PostazioniMapo UPDATE [PostazioniMapo] SET [IdxPostazione] = @IdxPostazione, [DescPostazione] = @DescPostazione, [IdxMacchina] = @IdxMacchina, [MatrOperatore] = @MatrOperatore, [InputUntil] = @InputUntil, [LastBarcode] = @LastBarcode WHERE (([IdxPostazione] = @Original_IdxPostazione) AND ((@IsNull_DescPostazione = 1 AND [DescPostazione] IS NULL) OR ([DescPostazione] = @Original_DescPostazione)) AND ([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_MatrOperatore = 1 AND [MatrOperatore] IS NULL) OR ([MatrOperatore] = @Original_MatrOperatore)) AND ((@IsNull_InputUntil = 1 AND [InputUntil] IS NULL) OR ([InputUntil] = @Original_InputUntil)) AND ((@IsNull_LastBarcode = 1 AND [LastBarcode] IS NULL) OR ([LastBarcode] = @Original_LastBarcode))); SELECT IdxPostazione, DescPostazione, IdxMacchina, MatrOperatore, InputUntil, LastBarcode FROM PostazioniMapo WHERE (IdxPostazione = @IdxPostazione) dbo.stp_POST_getByIdPostazione dbo.stp_POST_updateMacchina dbo.stp_POST_updateOperatoreAdmin dbo.stp_PzProd_getByMacchina dbo.stp_PzProd_getByMacchinaPeriodo dbo.stp_ConfermaProduzCompleta dbo.stp_ConfermaProduzCompletaFull dbo.stp_DatiConf_conferma DELETE FROM [dbo].[DatiConfermati] WHERE (([IdxConferma] = @Original_IdxConferma) AND ([IdxODL] = @Original_IdxODL) AND ([DataOraApp] = @Original_DataOraApp) AND ([DataRif] = @Original_DataRif) AND ((@IsNull_TurnoRif = 1 AND [TurnoRif] IS NULL) OR ([TurnoRif] = @Original_TurnoRif)) AND ((@IsNull_CodArticolo = 1 AND [CodArticolo] IS NULL) OR ([CodArticolo] = @Original_CodArticolo)) AND ([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_TCAssegnato = 1 AND [TCAssegnato] IS NULL) OR ([TCAssegnato] = @Original_TCAssegnato)) AND ((@IsNull_MatrOpr = 1 AND [MatrOpr] IS NULL) OR ([MatrOpr] = @Original_MatrOpr)) AND ([MatrApp] = @Original_MatrApp) AND ((@IsNull_DataOraFrom = 1 AND [DataOraFrom] IS NULL) OR ([DataOraFrom] = @Original_DataOraFrom)) AND ((@IsNull_DataOraTo = 1 AND [DataOraTo] IS NULL) OR ([DataOraTo] = @Original_DataOraTo)) AND ([IdxStato] = @Original_IdxStato) AND ((@IsNull_TotPzProd = 1 AND [TotPzProd] IS NULL) OR ([TotPzProd] = @Original_TotPzProd)) AND ((@IsNull_TempoProdotto = 1 AND [TempoProdotto] IS NULL) OR ([TempoProdotto] = @Original_TempoProdotto)) AND ((@IsNull_TempoCron = 1 AND [TempoCron] IS NULL) OR ([TempoCron] = @Original_TempoCron)) AND ((@IsNull_TempoND = 1 AND [TempoND] IS NULL) OR ([TempoND] = @Original_TempoND)) AND ((@IsNull_TempoApertura = 1 AND [TempoApertura] IS NULL) OR ([TempoApertura] = @Original_TempoApertura)) AND ((@IsNull_TempoOFF = 1 AND [TempoOFF] IS NULL) OR ([TempoOFF] = @Original_TempoOFF)) AND ((@IsNull_TempoON = 1 AND [TempoON] IS NULL) OR ([TempoON] = @Original_TempoON)) AND ((@IsNull_TempoFermoOn = 1 AND [TempoFermoOn] IS NULL) OR ([TempoFermoOn] = @Original_TempoFermoOn)) AND ((@IsNull_TempoAuto = 1 AND [TempoAuto] IS NULL) OR ([TempoAuto] = @Original_TempoAuto)) AND ((@IsNull_TempoFermoAuto = 1 AND [TempoFermoAuto] IS NULL) OR ([TempoFermoAuto] = @Original_TempoFermoAuto)) AND ((@IsNull_TempoRun = 1 AND [TempoRun] IS NULL) OR ([TempoRun] = @Original_TempoRun)) AND ((@IsNull_TotPzFermo = 1 AND [TotPzFermo] IS NULL) OR ([TotPzFermo] = @Original_TotPzFermo))) INSERT INTO [dbo].[DatiConfermati] ([IdxODL], [DataOraApp], [DataRif], [TurnoRif], [CodArticolo], [IdxMacchina], [TCAssegnato], [MatrOpr], [MatrApp], [DataOraFrom], [DataOraTo], [IdxStato], [TotPzProd], [TempoProdotto], [TempoCron], [TempoND], [TempoApertura], [TempoOFF], [TempoON], [TempoFermoOn], [TempoAuto], [TempoFermoAuto], [TempoRun], [TotPzFermo]) VALUES (@IdxODL, @DataOraApp, @DataRif, @TurnoRif, @CodArticolo, @IdxMacchina, @TCAssegnato, @MatrOpr, @MatrApp, @DataOraFrom, @DataOraTo, @IdxStato, @TotPzProd, @TempoProdotto, @TempoCron, @TempoND, @TempoApertura, @TempoOFF, @TempoON, @TempoFermoOn, @TempoAuto, @TempoFermoAuto, @TempoRun, @TotPzFermo); SELECT IdxConferma, IdxODL, DataOraApp, DataRif, TurnoRif, CodArticolo, IdxMacchina, TCAssegnato, MatrOpr, MatrApp, DataOraFrom, DataOraTo, IdxStato, TotPzProd, TempoProdotto, TempoCron, TempoND, TempoApertura, TempoOFF, TempoON, TempoFermoOn, TempoAuto, TempoFermoAuto, TempoRun, TotPzFermo FROM DatiConfermati WHERE (IdxConferma = SCOPE_IDENTITY()) SELECT IdxConferma, IdxODL, DataOraApp, DataRif, TurnoRif, CodArticolo, IdxMacchina, TCAssegnato, MatrOpr, MatrApp, DataOraFrom, DataOraTo, IdxStato, TotPzProd, TempoProdotto, TempoCron, TempoND, TempoApertura, TempoOFF, TempoON, TempoFermoOn, TempoAuto, TempoFermoAuto, TempoRun, TotPzFermo FROM dbo.DatiConfermati UPDATE [dbo].[DatiConfermati] SET [IdxODL] = @IdxODL, [DataOraApp] = @DataOraApp, [DataRif] = @DataRif, [TurnoRif] = @TurnoRif, [CodArticolo] = @CodArticolo, [IdxMacchina] = @IdxMacchina, [TCAssegnato] = @TCAssegnato, [MatrOpr] = @MatrOpr, [MatrApp] = @MatrApp, [DataOraFrom] = @DataOraFrom, [DataOraTo] = @DataOraTo, [IdxStato] = @IdxStato, [TotPzProd] = @TotPzProd, [TempoProdotto] = @TempoProdotto, [TempoCron] = @TempoCron, [TempoND] = @TempoND, [TempoApertura] = @TempoApertura, [TempoOFF] = @TempoOFF, [TempoON] = @TempoON, [TempoFermoOn] = @TempoFermoOn, [TempoAuto] = @TempoAuto, [TempoFermoAuto] = @TempoFermoAuto, [TempoRun] = @TempoRun, [TotPzFermo] = @TotPzFermo WHERE (([IdxConferma] = @Original_IdxConferma) AND ([IdxODL] = @Original_IdxODL) AND ([DataOraApp] = @Original_DataOraApp) AND ([DataRif] = @Original_DataRif) AND ((@IsNull_TurnoRif = 1 AND [TurnoRif] IS NULL) OR ([TurnoRif] = @Original_TurnoRif)) AND ((@IsNull_CodArticolo = 1 AND [CodArticolo] IS NULL) OR ([CodArticolo] = @Original_CodArticolo)) AND ([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_TCAssegnato = 1 AND [TCAssegnato] IS NULL) OR ([TCAssegnato] = @Original_TCAssegnato)) AND ((@IsNull_MatrOpr = 1 AND [MatrOpr] IS NULL) OR ([MatrOpr] = @Original_MatrOpr)) AND ([MatrApp] = @Original_MatrApp) AND ((@IsNull_DataOraFrom = 1 AND [DataOraFrom] IS NULL) OR ([DataOraFrom] = @Original_DataOraFrom)) AND ((@IsNull_DataOraTo = 1 AND [DataOraTo] IS NULL) OR ([DataOraTo] = @Original_DataOraTo)) AND ([IdxStato] = @Original_IdxStato) AND ((@IsNull_TotPzProd = 1 AND [TotPzProd] IS NULL) OR ([TotPzProd] = @Original_TotPzProd)) AND ((@IsNull_TempoProdotto = 1 AND [TempoProdotto] IS NULL) OR ([TempoProdotto] = @Original_TempoProdotto)) AND ((@IsNull_TempoCron = 1 AND [TempoCron] IS NULL) OR ([TempoCron] = @Original_TempoCron)) AND ((@IsNull_TempoND = 1 AND [TempoND] IS NULL) OR ([TempoND] = @Original_TempoND)) AND ((@IsNull_TempoApertura = 1 AND [TempoApertura] IS NULL) OR ([TempoApertura] = @Original_TempoApertura)) AND ((@IsNull_TempoOFF = 1 AND [TempoOFF] IS NULL) OR ([TempoOFF] = @Original_TempoOFF)) AND ((@IsNull_TempoON = 1 AND [TempoON] IS NULL) OR ([TempoON] = @Original_TempoON)) AND ((@IsNull_TempoFermoOn = 1 AND [TempoFermoOn] IS NULL) OR ([TempoFermoOn] = @Original_TempoFermoOn)) AND ((@IsNull_TempoAuto = 1 AND [TempoAuto] IS NULL) OR ([TempoAuto] = @Original_TempoAuto)) AND ((@IsNull_TempoFermoAuto = 1 AND [TempoFermoAuto] IS NULL) OR ([TempoFermoAuto] = @Original_TempoFermoAuto)) AND ((@IsNull_TempoRun = 1 AND [TempoRun] IS NULL) OR ([TempoRun] = @Original_TempoRun)) AND ((@IsNull_TotPzFermo = 1 AND [TotPzFermo] IS NULL) OR ([TotPzFermo] = @Original_TotPzFermo))); SELECT IdxConferma, IdxODL, DataOraApp, DataRif, TurnoRif, CodArticolo, IdxMacchina, TCAssegnato, MatrOpr, MatrApp, DataOraFrom, DataOraTo, IdxStato, TotPzProd, TempoProdotto, TempoCron, TempoND, TempoApertura, TempoOFF, TempoON, TempoFermoOn, TempoAuto, TempoFermoAuto, TempoRun, TotPzFermo FROM DatiConfermati WHERE (IdxConferma = @IdxConferma) dbo.stp_DatiConf_getByMacchPeriodo SELECT TOP (1) IdxConferma, IdxODL, DataOraApp, DataRif, TurnoRif, CodArticolo IdxMacchina, TCAssegnato, MatrOpr, MatrApp, DataOraFrom, DataOraTo, IdxStato, TotPzProd, TempoProdotto, TempoCron, TempoND, TempoApertura, TempoOFF, TempoON, TempoFermoOn, TempoAuto, TempoFermoAuto, TempoRun, TotPzFermo FROM DatiConfermati WHERE (IdxMacchina = @IdxMacchina) DELETE FROM [dbo].[CalendFesteFerie] WHERE (([data] = @Original_data) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione))) INSERT INTO [dbo].[CalendFesteFerie] ([data], [descrizione]) VALUES (@data, @descrizione); SELECT data, descrizione FROM CalendFesteFerie WHERE (data = @data) SELECT data, descrizione FROM dbo.CalendFesteFerie UPDATE [dbo].[CalendFesteFerie] SET [data] = @data, [descrizione] = @descrizione WHERE (([data] = @Original_data) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione))); SELECT data, descrizione FROM CalendFesteFerie WHERE (data = @data) dbo.stp_TempoByIdxMaccPeriodClass DELETE FROM [dbo].[DatiProduzione] WHERE (([IdxConferma] = @Original_IdxConferma) AND ([IdxODL] = @Original_IdxODL) AND ([DataOraApp] = @Original_DataOraApp) AND ([DataRif] = @Original_DataRif) AND ((@IsNull_TurnoRif = 1 AND [TurnoRif] IS NULL) OR ([TurnoRif] = @Original_TurnoRif)) AND ((@IsNull_CodArticolo = 1 AND [CodArticolo] IS NULL) OR ([CodArticolo] = @Original_CodArticolo)) AND ([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_TCAssegnato = 1 AND [TCAssegnato] IS NULL) OR ([TCAssegnato] = @Original_TCAssegnato)) AND ((@IsNull_MatrOpr = 1 AND [MatrOpr] IS NULL) OR ([MatrOpr] = @Original_MatrOpr)) AND ([MatrApp] = @Original_MatrApp) AND ((@IsNull_DataOraFrom = 1 AND [DataOraFrom] IS NULL) OR ([DataOraFrom] = @Original_DataOraFrom)) AND ((@IsNull_DataOraTo = 1 AND [DataOraTo] IS NULL) OR ([DataOraTo] = @Original_DataOraTo)) AND ((@IsNull_TotPzProd = 1 AND [TotPzProd] IS NULL) OR ([TotPzProd] = @Original_TotPzProd)) AND ((@IsNull_Tempo = 1 AND [Tempo] IS NULL) OR ([Tempo] = @Original_Tempo)) AND ((@IsNull_ClasseTempo = 1 AND [ClasseTempo] IS NULL) OR ([ClasseTempo] = @Original_ClasseTempo)) AND ((@IsNull_Causale = 1 AND [Causale] IS NULL) OR ([Causale] = @Original_Causale))) INSERT INTO [dbo].[DatiProduzione] ([IdxODL], [DataOraApp], [DataRif], [TurnoRif], [CodArticolo], [IdxMacchina], [TCAssegnato], [MatrOpr], [MatrApp], [DataOraFrom], [DataOraTo], [TotPzProd], [Tempo], [ClasseTempo], [Causale]) VALUES (@IdxODL, @DataOraApp, @DataRif, @TurnoRif, @CodArticolo, @IdxMacchina, @TCAssegnato, @MatrOpr, @MatrApp, @DataOraFrom, @DataOraTo, @TotPzProd, @Tempo, @ClasseTempo, @Causale); SELECT IdxConferma, IdxODL, DataOraApp, DataRif, TurnoRif, CodArticolo, IdxMacchina, TCAssegnato, MatrOpr, MatrApp, DataOraFrom, DataOraTo, TotPzProd, Tempo, ClasseTempo, Causale FROM DatiProduzione WHERE (IdxConferma = SCOPE_IDENTITY()) SELECT * FROM dbo.DatiProduzione UPDATE [dbo].[DatiProduzione] SET [IdxODL] = @IdxODL, [DataOraApp] = @DataOraApp, [DataRif] = @DataRif, [TurnoRif] = @TurnoRif, [CodArticolo] = @CodArticolo, [IdxMacchina] = @IdxMacchina, [TCAssegnato] = @TCAssegnato, [MatrOpr] = @MatrOpr, [MatrApp] = @MatrApp, [DataOraFrom] = @DataOraFrom, [DataOraTo] = @DataOraTo, [TotPzProd] = @TotPzProd, [Tempo] = @Tempo, [ClasseTempo] = @ClasseTempo, [Causale] = @Causale WHERE (([IdxConferma] = @Original_IdxConferma) AND ([IdxODL] = @Original_IdxODL) AND ([DataOraApp] = @Original_DataOraApp) AND ([DataRif] = @Original_DataRif) AND ((@IsNull_TurnoRif = 1 AND [TurnoRif] IS NULL) OR ([TurnoRif] = @Original_TurnoRif)) AND ((@IsNull_CodArticolo = 1 AND [CodArticolo] IS NULL) OR ([CodArticolo] = @Original_CodArticolo)) AND ([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_TCAssegnato = 1 AND [TCAssegnato] IS NULL) OR ([TCAssegnato] = @Original_TCAssegnato)) AND ((@IsNull_MatrOpr = 1 AND [MatrOpr] IS NULL) OR ([MatrOpr] = @Original_MatrOpr)) AND ([MatrApp] = @Original_MatrApp) AND ((@IsNull_DataOraFrom = 1 AND [DataOraFrom] IS NULL) OR ([DataOraFrom] = @Original_DataOraFrom)) AND ((@IsNull_DataOraTo = 1 AND [DataOraTo] IS NULL) OR ([DataOraTo] = @Original_DataOraTo)) AND ((@IsNull_TotPzProd = 1 AND [TotPzProd] IS NULL) OR ([TotPzProd] = @Original_TotPzProd)) AND ((@IsNull_Tempo = 1 AND [Tempo] IS NULL) OR ([Tempo] = @Original_Tempo)) AND ((@IsNull_ClasseTempo = 1 AND [ClasseTempo] IS NULL) OR ([ClasseTempo] = @Original_ClasseTempo)) AND ((@IsNull_Causale = 1 AND [Causale] IS NULL) OR ([Causale] = @Original_Causale))); SELECT IdxConferma, IdxODL, DataOraApp, DataRif, TurnoRif, CodArticolo, IdxMacchina, TCAssegnato, MatrOpr, MatrApp, DataOraFrom, DataOraTo, TotPzProd, Tempo, ClasseTempo, Causale FROM DatiProduzione WHERE (IdxConferma = @IdxConferma) dbo.stp_DatiProd_getByMacchPeriodo dbo.stp_DatiProd_getByPeriodo dbo.stp_DatiProd_insAllPeriodo dbo.stp_DatiProd_insert dbo.stp_repDonati_getDatiProdMacchina dbo.stp_repDonati_getLastStatoDurataMacchina dbo.stp_repDonati_getDatiProdMacchinaPeriodo DELETE FROM [dbo].[TurniMacchina] WHERE (([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_T1 = 1 AND [T1] IS NULL) OR ([T1] = @Original_T1)) AND ((@IsNull_T2 = 1 AND [T2] IS NULL) OR ([T2] = @Original_T2)) AND ((@IsNull_T3 = 1 AND [T3] IS NULL) OR ([T3] = @Original_T3))) INSERT INTO [dbo].[TurniMacchina] ([IdxMacchina], [T1], [T2], [T3]) VALUES (@IdxMacchina, @T1, @T2, @T3); SELECT IdxMacchina, T1, T2, T3 FROM TurniMacchina WHERE (IdxMacchina = @IdxMacchina) SELECT IdxMacchina, T1, T2, T3 FROM dbo.TurniMacchina UPDATE [dbo].[TurniMacchina] SET [IdxMacchina] = @IdxMacchina, [T1] = @T1, [T2] = @T2, [T3] = @T3 WHERE (([IdxMacchina] = @Original_IdxMacchina) AND ((@IsNull_T1 = 1 AND [T1] IS NULL) OR ([T1] = @Original_T1)) AND ((@IsNull_T2 = 1 AND [T2] IS NULL) OR ([T2] = @Original_T2)) AND ((@IsNull_T3 = 1 AND [T3] IS NULL) OR ([T3] = @Original_T3))); SELECT IdxMacchina, T1, T2, T3 FROM TurniMacchina WHERE (IdxMacchina = @IdxMacchina) dbo.stp_turniMacchineByIdxMacc dbo.stp_turniMacchineUpdateTurno DELETE FROM [MappaStatoExpl] WHERE (([RowNum] = @Original_RowNum) AND ((@IsNull_lastUpdate = 1 AND [lastUpdate] IS NULL) OR ([lastUpdate] = @Original_lastUpdate)) AND ((@IsNull_IdxMacchina = 1 AND [IdxMacchina] IS NULL) OR ([IdxMacchina] = @Original_IdxMacchina)) AND ((@IsNull_CodMacchina = 1 AND [CodMacchina] IS NULL) OR ([CodMacchina] = @Original_CodMacchina)) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_url = 1 AND [url] IS NULL) OR ([url] = @Original_url)) AND ((@IsNull_idxODL = 1 AND [idxODL] IS NULL) OR ([idxODL] = @Original_idxODL)) AND ((@IsNull_idxPODL = 1 AND [idxPODL] IS NULL) OR ([idxPODL] = @Original_idxPODL)) AND ((@IsNull_CodArticolo = 1 AND [CodArticolo] IS NULL) OR ([CodArticolo] = @Original_CodArticolo)) AND ((@IsNull_Disegno = 1 AND [Disegno] IS NULL) OR ([Disegno] = @Original_Disegno)) AND ((@IsNull_NumPezzi = 1 AND [NumPezzi] IS NULL) OR ([NumPezzi] = @Original_NumPezzi)) AND ((@IsNull_TCAssegnato = 1 AND [TCAssegnato] IS NULL) OR ([TCAssegnato] = @Original_TCAssegnato)) AND ((@IsNull_DataInizioODL = 1 AND [DataInizioODL] IS NULL) OR ([DataInizioODL] = @Original_DataInizioODL)) AND ((@IsNull_Semaforo = 1 AND [Semaforo] IS NULL) OR ([Semaforo] = @Original_Semaforo)) AND ((@IsNull_idxStato = 1 AND [idxStato] IS NULL) OR ([idxStato] = @Original_idxStato)) AND ((@IsNull_DescrizioneStato = 1 AND [DescrizioneStato] IS NULL) OR ([DescrizioneStato] = @Original_DescrizioneStato)) AND ((@IsNull_durata = 1 AND [durata] IS NULL) OR ([durata] = @Original_durata)) AND ((@IsNull_PezziProd = 1 AND [PezziProd] IS NULL) OR ([PezziProd] = @Original_PezziProd)) AND ((@IsNull_PezziConf = 1 AND [PezziConf] IS NULL) OR ([PezziConf] = @Original_PezziConf)) AND ((@IsNull_TempoOn = 1 AND [TempoOn] IS NULL) OR ([TempoOn] = @Original_TempoOn)) AND ((@IsNull_TempoAuto = 1 AND [TempoAuto] IS NULL) OR ([TempoAuto] = @Original_TempoAuto)) AND ((@IsNull_TempoRun = 1 AND [TempoRun] IS NULL) OR ([TempoRun] = @Original_TempoRun)) AND ((@IsNull_TCMedio = 1 AND [TCMedio] IS NULL) OR ([TCMedio] = @Original_TCMedio)) AND ((@IsNull_TCLav = 1 AND [TCLav] IS NULL) OR ([TCLav] = @Original_TCLav)) AND ((@IsNull_TCEff = 1 AND [TCEff] IS NULL) OR ([TCEff] = @Original_TCEff)) AND ((@IsNull_TCMedioRT = 1 AND [TCMedioRT] IS NULL) OR ([TCMedioRT] = @Original_TCMedioRT)) AND ((@IsNull_TCLavRT = 1 AND [TCLavRT] IS NULL) OR ([TCLavRT] = @Original_TCLavRT)) AND ((@IsNull_TCEffRT = 1 AND [TCEffRT] IS NULL) OR ([TCEffRT] = @Original_TCEffRT))) INSERT INTO [MappaStatoExpl] ([lastUpdate], [IdxMacchina], [CodMacchina], [Nome], [url], [idxODL], [idxPODL], [CodArticolo], [Disegno], [NumPezzi], [TCAssegnato], [DataInizioODL], [Semaforo], [idxStato], [DescrizioneStato], [durata], [PezziProd], [PezziConf], [TempoOn], [TempoAuto], [TempoRun], [TCMedio], [TCLav], [TCEff], [TCMedioRT], [TCLavRT], [TCEffRT]) VALUES (@lastUpdate, @IdxMacchina, @CodMacchina, @Nome, @url, @idxODL, @idxPODL, @CodArticolo, @Disegno, @NumPezzi, @TCAssegnato, @DataInizioODL, @Semaforo, @idxStato, @DescrizioneStato, @durata, @PezziProd, @PezziConf, @TempoOn, @TempoAuto, @TempoRun, @TCMedio, @TCLav, @TCEff, @TCMedioRT, @TCLavRT, @TCEffRT) SELECT * FROM MappaStatoExpl UPDATE [MappaStatoExpl] SET [lastUpdate] = @lastUpdate, [CodMacchina] = @CodMacchina, [Nome] = @Nome, [url] = @url, [idxODL] = @idxODL, [idxPODL] = @idxPODL, [CodArticolo] = @CodArticolo, [Disegno] = @Disegno, [NumPezzi] = @NumPezzi, [TCAssegnato] = @TCAssegnato, [DataInizioODL] = @DataInizioODL, [Semaforo] = @Semaforo, [idxStato] = @idxStato, [DescrizioneStato] = @DescrizioneStato, [durata] = @durata, [PezziProd] = @PezziProd, [PezziConf] = @PezziConf, [TempoOn] = @TempoOn, [TempoAuto] = @TempoAuto, [TempoRun] = @TempoRun, [TCMedio] = @TCMedio, [TCLav] = @TCLav, [TCEff] = @TCEff, [TCMedioRT] = @TCMedioRT, [TCLavRT] = @TCLavRT, [TCEffRT] = @TCEffRT WHERE (([RowNum] = @Original_RowNum) AND ((@IsNull_lastUpdate = 1 AND [lastUpdate] IS NULL) OR ([lastUpdate] = @Original_lastUpdate)) AND ((@IsNull_CodMacchina = 1 AND [CodMacchina] IS NULL) OR ([CodMacchina] = @Original_CodMacchina)) AND ((@IsNull_Nome = 1 AND [Nome] IS NULL) OR ([Nome] = @Original_Nome)) AND ((@IsNull_url = 1 AND [url] IS NULL) OR ([url] = @Original_url)) AND ((@IsNull_idxODL = 1 AND [idxODL] IS NULL) OR ([idxODL] = @Original_idxODL)) AND ((@IsNull_idxPODL = 1 AND [idxPODL] IS NULL) OR ([idxPODL] = @Original_idxPODL)) AND ((@IsNull_CodArticolo = 1 AND [CodArticolo] IS NULL) OR ([CodArticolo] = @Original_CodArticolo)) AND ((@IsNull_Disegno = 1 AND [Disegno] IS NULL) OR ([Disegno] = @Original_Disegno)) AND ((@IsNull_NumPezzi = 1 AND [NumPezzi] IS NULL) OR ([NumPezzi] = @Original_NumPezzi)) AND ((@IsNull_TCAssegnato = 1 AND [TCAssegnato] IS NULL) OR ([TCAssegnato] = @Original_TCAssegnato)) AND ((@IsNull_DataInizioODL = 1 AND [DataInizioODL] IS NULL) OR ([DataInizioODL] = @Original_DataInizioODL)) AND ((@IsNull_Semaforo = 1 AND [Semaforo] IS NULL) OR ([Semaforo] = @Original_Semaforo)) AND ((@IsNull_idxStato = 1 AND [idxStato] IS NULL) OR ([idxStato] = @Original_idxStato)) AND ((@IsNull_DescrizioneStato = 1 AND [DescrizioneStato] IS NULL) OR ([DescrizioneStato] = @Original_DescrizioneStato)) AND ((@IsNull_durata = 1 AND [durata] IS NULL) OR ([durata] = @Original_durata)) AND ((@IsNull_PezziProd = 1 AND [PezziProd] IS NULL) OR ([PezziProd] = @Original_PezziProd)) AND ((@IsNull_PezziConf = 1 AND [PezziConf] IS NULL) OR ([PezziConf] = @Original_PezziConf)) AND ((@IsNull_TempoOn = 1 AND [TempoOn] IS NULL) OR ([TempoOn] = @Original_TempoOn)) AND ((@IsNull_TempoAuto = 1 AND [TempoAuto] IS NULL) OR ([TempoAuto] = @Original_TempoAuto)) AND ((@IsNull_TempoRun = 1 AND [TempoRun] IS NULL) OR ([TempoRun] = @Original_TempoRun)) AND ((@IsNull_TCMedio = 1 AND [TCMedio] IS NULL) OR ([TCMedio] = @Original_TCMedio)) AND ((@IsNull_TCLav = 1 AND [TCLav] IS NULL) OR ([TCLav] = @Original_TCLav)) AND ((@IsNull_TCEff = 1 AND [TCEff] IS NULL) OR ([TCEff] = @Original_TCEff)) AND ((@IsNull_TCMedioRT = 1 AND [TCMedioRT] IS NULL) OR ([TCMedioRT] = @Original_TCMedioRT)) AND ((@IsNull_TCLavRT = 1 AND [TCLavRT] IS NULL) OR ([TCLavRT] = @Original_TCLavRT)) AND ((@IsNull_TCEffRT = 1 AND [TCEffRT] IS NULL) OR ([TCEffRT] = @Original_TCEffRT))); SELECT RowNum, lastUpdate, CodMacchina, Nome, url, idxODL, idxPODL, CodArticolo, Disegno, NumPezzi, TCAssegnato, DataInizioODL, Semaforo, idxStato, DescrizioneStato, durata, PezziProd, PezziConf, TempoOn, TempoAuto, TempoRun, TCMedio, TCLav, TCEff, TCMedioRT, TCLavRT, TCEffRT FROM MappaStatoExpl WHERE (RowNum = @RowNum) dbo.stp_MSE_recalc dbo.stp_MSE_getByIdxMacchAndSub dbo.stp_MSE_getByIdxMacchina dbo.stp_MSE_getData dbo.stp_MSE_getDataByOpr dbo.stp_ResProdDett_splitODL dbo.stp_ResProdDett_splitGG dbo.stp_ResProd_getByPeriodo SELECT * FROM v_RegistroControlli dbo.stp_RC_getByFilt dbo.stp_RC_getLast dbo.stp_RC_insert SELECT * FROM dbo.v_RegistroScarti dbo.stp_RS_getByFilt dbo.stp_RS_pending dbo.stp_RS_totPending dbo.stp_RS_insert dbo.stp_RS_recProd SELECT * FROM v_PODL_exp ORDER BY idxPromessa DESC dbo.stp_PODL_deleteQuery dbo.stp_PODL_getByCodArt dbo.stp_PODL_getByIdxMacc dbo.stp_PODL_getByIdxOdl dbo.stp_PODL_getByIdx dbo.stp_PODL_getByMaccArt dbo.stp_PODL_getByMultiMacc dbo.stp_PODL_insertQuery dbo.stp_PODL_updateQta dbo.stp_PODL_updateQuery SELECT * FROM v_ECP dbo.stp_ECP_getByMacchinaPeriodo dbo.stp_StatoProd_getByMacchina dbo.stp_StatoProd_getByMacchinaData DELETE FROM [Macchine2Slave] WHERE (([IdxMacchina] = @Original_IdxMacchina) AND ([IdxMacchinaSlave] = @Original_IdxMacchinaSlave)) INSERT INTO [Macchine2Slave] ([IdxMacchina], [IdxMacchinaSlave]) VALUES (@IdxMacchina, @IdxMacchinaSlave); SELECT IdxMacchina, IdxMacchinaSlave FROM Macchine2Slave WHERE (IdxMacchina = @IdxMacchina) AND (IdxMacchinaSlave = @IdxMacchinaSlave) SELECT IdxMacchina, IdxMacchinaSlave FROM Macchine2Slave UPDATE [Macchine2Slave] SET [IdxMacchina] = @IdxMacchina, [IdxMacchinaSlave] = @IdxMacchinaSlave WHERE (([IdxMacchina] = @Original_IdxMacchina) AND ([IdxMacchinaSlave] = @Original_IdxMacchinaSlave)); SELECT IdxMacchina, IdxMacchinaSlave FROM Macchine2Slave WHERE (IdxMacchina = @IdxMacchina) AND (IdxMacchinaSlave = @IdxMacchinaSlave) dbo.stp_M2S_byMaster dbo.stp_M2S_bySlave