SELECT * FROM v_planStatsGlobal dbo.stp_PSG_filt SELECT * FROM dbo.v_planStatsArt ORDER BY TotOreRich DESC dbo.stp_PSA_filt SELECT * FROM dbo.v_planStatsGroup ORDER BY TotOreRich DESC SELECT * FROM dbo.v_planStatsMacc ORDER BY TotOreRich DESC dbo.stp_PSM_filt SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, NoteRichiesta, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note, CodCliente, flgPromDirty, DateAllOdlClose, DescrGruppo, nomeMacc, DescrMacc, Disegno, DescArticolo, DescCliente, TC50p, TC_Type, TotMinuti, TotQty, QtaRem FROM v_RichiesteAperte dbo.stp_IST_alloca dbo.stp_IST_approva dbo.stp_IST_grp dbo.stp_Richieste_filt DELETE FROM [dbo].[PromesseIN] WHERE (([idxPromessa] = @Original_idxPromessa) AND ([KeyRichiesta] = @Original_KeyRichiesta) AND ([KeyBCode] = @Original_KeyBCode) AND ([Attivabile] = @Original_Attivabile) AND ([IdxODL] = @Original_IdxODL) AND ([CodArticolo] = @Original_CodArticolo) AND ([CodGruppo] = @Original_CodGruppo) AND ([IdxMacchina] = @Original_IdxMacchina) AND ([NumPezzi] = @Original_NumPezzi) AND ([TCAssegnato] = @Original_TCAssegnato) AND ([DueDate] = @Original_DueDate) AND ([Priorita] = @Original_Priorita) AND ([PzPallet] = @Original_PzPallet) AND ([Note] = @Original_Note)) INSERT INTO [dbo].[PromesseIN] ([KeyRichiesta], [KeyBCode], [Attivabile], [IdxODL], [CodArticolo], [CodGruppo], [IdxMacchina], [NumPezzi], [TCAssegnato], [DueDate], [Priorita], [PzPallet], [Note]) VALUES (@KeyRichiesta, @KeyBCode, @Attivabile, @IdxODL, @CodArticolo, @CodGruppo, @IdxMacchina, @NumPezzi, @TCAssegnato, @DueDate, @Priorita, @PzPallet, @Note); SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note FROM PromesseIN WHERE (idxPromessa = SCOPE_IDENTITY()) SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note FROM dbo.PromesseIN UPDATE [dbo].[PromesseIN] SET [KeyRichiesta] = @KeyRichiesta, [KeyBCode] = @KeyBCode, [Attivabile] = @Attivabile, [IdxODL] = @IdxODL, [CodArticolo] = @CodArticolo, [CodGruppo] = @CodGruppo, [IdxMacchina] = @IdxMacchina, [NumPezzi] = @NumPezzi, [TCAssegnato] = @TCAssegnato, [DueDate] = @DueDate, [Priorita] = @Priorita, [PzPallet] = @PzPallet, [Note] = @Note WHERE (([idxPromessa] = @Original_idxPromessa) AND ([KeyRichiesta] = @Original_KeyRichiesta) AND ([KeyBCode] = @Original_KeyBCode) AND ([Attivabile] = @Original_Attivabile) AND ([IdxODL] = @Original_IdxODL) AND ([CodArticolo] = @Original_CodArticolo) AND ([CodGruppo] = @Original_CodGruppo) AND ([IdxMacchina] = @Original_IdxMacchina) AND ([NumPezzi] = @Original_NumPezzi) AND ([TCAssegnato] = @Original_TCAssegnato) AND ([DueDate] = @Original_DueDate) AND ([Priorita] = @Original_Priorita) AND ([PzPallet] = @Original_PzPallet) AND ([Note] = @Original_Note)); SELECT idxPromessa, KeyRichiesta, KeyBCode, Attivabile, IdxODL, CodArticolo, CodGruppo, IdxMacchina, NumPezzi, TCAssegnato, DueDate, Priorita, PzPallet, Note FROM PromesseIN WHERE (idxPromessa = @idxPromessa) dbo.stp_PODL_IN_updProc SELECT * FROM v_PODL_OUT_exp dbo.stp_PODL_OUT_deleteQuery dbo.stp_PODL_OUT_getByMaccArt dbo.stp_PODL_OUT_getMaxPrioByMacc dbo.stp_PODL_OUT_insertQuery dbo.stp_PODL_OUT_move dbo.stp_PODL_OUT_updAttiva dbo.stp_PODL_OUT_updMacchina SELECT * FROM ConfWeek SELECT * FROM CalStop dbo.stp_CalS_getByPeriod dbo.stp_CalS_upsert SELECT * FROM CalDisp dbo.stp_CalD_getByPeriod dbo.stp_CalD_UpdatePeriod SELECT * FROM ConfWeek SELECT * FROM MachineParams dbo.stp_MacPar_DeleteQuery dbo.stp_MacPar_insMissing dbo.stp_MacPar_UpdateQuery SELECT * FROM v_selConfWeek dbo.stp_HPSM_filt SELECT * FROM v_planStatsCli ORDER BY TotOreRich DESC dbo.stp_PSC_filt