DELETE FROM [dbo].[AnagSquadre] WHERE (([CodSquadra] = @Original_CodSquadra) AND ([DescrSquadra] = @Original_DescrSquadra) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform) AND ([Attiva] = @Original_Attiva) AND ([CssColor] = @Original_CssColor)) INSERT INTO [dbo].[AnagSquadre] ([CodSquadra], [DescrSquadra], [NumOp], [Elettrod], [Clima], [Inform], [Attiva], [CssColor]) VALUES (@CodSquadra, @DescrSquadra, @NumOp, @Elettrod, @Clima, @Inform, @Attiva, @CssColor); SELECT CodSquadra, DescrSquadra, NumOp, Elettrod, Clima, Inform, Attiva, CssColor FROM AnagSquadre WHERE (CodSquadra = @CodSquadra) SELECT * FROM dbo.AnagSquadre UPDATE [dbo].[AnagSquadre] SET [CodSquadra] = @CodSquadra, [DescrSquadra] = @DescrSquadra, [NumOp] = @NumOp, [Elettrod] = @Elettrod, [Clima] = @Clima, [Inform] = @Inform, [Attiva] = @Attiva, [CssColor] = @CssColor WHERE (([CodSquadra] = @Original_CodSquadra) AND ([DescrSquadra] = @Original_DescrSquadra) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform) AND ([Attiva] = @Original_Attiva) AND ([CssColor] = @Original_CssColor)); SELECT CodSquadra, DescrSquadra, NumOp, Elettrod, Clima, Inform, Attiva, CssColor FROM AnagSquadre WHERE (CodSquadra = @CodSquadra) dbo.stp_AS_DeleteQuery dbo.stp_AS_getAttive dbo.stp_AS_getByKey dbo.stp_AS_InsertQuery dbo.stp_AS_UpdateQuery DELETE FROM [AnagZone] WHERE (([idxZona] = @Original_idxZona) AND ([Cap] = @Original_Cap) AND ([Localita] = @Original_Localita) AND ([Prov] = @Original_Prov) AND ([Tempo] = @Original_Tempo) AND ([Zona] = @Original_Zona)) INSERT INTO [AnagZone] ([Cap], [Localita], [Prov], [Tempo], [Zona]) VALUES (@Cap, @Localita, @Prov, @Tempo, @Zona); SELECT idxZona, Cap, Localita, Prov, Tempo, Zona FROM AnagZone WHERE (idxZona = SCOPE_IDENTITY()) ORDER BY Zona SELECT * FROM AnagZone ORDER BY Zona UPDATE [AnagZone] SET [Cap] = @Cap, [Localita] = @Localita, [Prov] = @Prov, [Tempo] = @Tempo, [Zona] = @Zona WHERE (([idxZona] = @Original_idxZona) AND ([Cap] = @Original_Cap) AND ([Localita] = @Original_Localita) AND ([Prov] = @Original_Prov) AND ([Tempo] = @Original_Tempo) AND ([Zona] = @Original_Zona)); SELECT idxZona, Cap, Localita, Prov, Tempo, Zona FROM AnagZone WHERE (idxZona = @idxZona) ORDER BY Zona dbo.stp_AZ_DeleteQuery dbo.stp_AZ_InsertQuery dbo.stp_AZ_UpdateQuery DELETE FROM [dbo].[AnagTipoConsegne] WHERE (([CodConsegna] = @Original_CodConsegna) AND ([DescrConsegna] = @Original_DescrConsegna) AND ([MinutiStd] = @Original_MinutiStd) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform)) INSERT INTO [dbo].[AnagTipoConsegne] ([CodConsegna], [DescrConsegna], [MinutiStd], [NumOp], [Elettrod], [Clima], [Inform]) VALUES (@CodConsegna, @DescrConsegna, @MinutiStd, @NumOp, @Elettrod, @Clima, @Inform); SELECT CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform FROM AnagTipoConsegne WHERE (CodConsegna = @CodConsegna) SELECT CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform FROM dbo.AnagTipoConsegne UPDATE [dbo].[AnagTipoConsegne] SET [CodConsegna] = @CodConsegna, [DescrConsegna] = @DescrConsegna, [MinutiStd] = @MinutiStd, [NumOp] = @NumOp, [Elettrod] = @Elettrod, [Clima] = @Clima, [Inform] = @Inform WHERE (([CodConsegna] = @Original_CodConsegna) AND ([DescrConsegna] = @Original_DescrConsegna) AND ([MinutiStd] = @Original_MinutiStd) AND ([NumOp] = @Original_NumOp) AND ([Elettrod] = @Original_Elettrod) AND ([Clima] = @Original_Clima) AND ([Inform] = @Original_Inform)); SELECT CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform FROM AnagTipoConsegne WHERE (CodConsegna = @CodConsegna) dbo.stp_ATC_DeleteQuery dbo.stp_ATC_getByKey dbo.stp_ATC_InsertQuery dbo.stp_ATC_UpdateQuery DELETE FROM [dbo].[AnagClienti] WHERE (([CodCliente] = @Original_CodCliente) AND ([RagSoc] = @Original_RagSoc) AND ((@IsNull_CodFis = 1 AND [CodFis] IS NULL) OR ([CodFis] = @Original_CodFis)) AND ((@IsNull_Tel = 1 AND [Tel] IS NULL) OR ([Tel] = @Original_Tel)) AND ((@IsNull_Cell = 1 AND [Cell] IS NULL) OR ([Cell] = @Original_Cell)) AND ([EnableSMS] = @Original_EnableSMS) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Indir = 1 AND [Indir] IS NULL) OR ([Indir] = @Original_Indir)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Prov = 1 AND [Prov] IS NULL) OR ([Prov] = @Original_Prov)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note))) INSERT INTO [dbo].[AnagClienti] ([CodCliente], [RagSoc], [CodFis], [Tel], [Cell], [EnableSMS], [Email], [Indir], [Cap], [Localita], [Prov], [Note]) VALUES (@CodCliente, @RagSoc, @CodFis, @Tel, @Cell, @EnableSMS, @Email, @Indir, @Cap, @Localita, @Prov, @Note); SELECT CodCliente, RagSoc, CodFis, Tel, Cell, EnableSMS, Email, Indir, Cap, Localita, Prov, Note FROM AnagClienti WHERE (CodCliente = @CodCliente) SELECT * FROM dbo.AnagClienti UPDATE [dbo].[AnagClienti] SET [CodCliente] = @CodCliente, [RagSoc] = @RagSoc, [CodFis] = @CodFis, [Tel] = @Tel, [Cell] = @Cell, [EnableSMS] = @EnableSMS, [Email] = @Email, [Indir] = @Indir, [Cap] = @Cap, [Localita] = @Localita, [Prov] = @Prov, [Note] = @Note WHERE (([CodCliente] = @Original_CodCliente) AND ([RagSoc] = @Original_RagSoc) AND ((@IsNull_CodFis = 1 AND [CodFis] IS NULL) OR ([CodFis] = @Original_CodFis)) AND ((@IsNull_Tel = 1 AND [Tel] IS NULL) OR ([Tel] = @Original_Tel)) AND ((@IsNull_Cell = 1 AND [Cell] IS NULL) OR ([Cell] = @Original_Cell)) AND ([EnableSMS] = @Original_EnableSMS) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Indir = 1 AND [Indir] IS NULL) OR ([Indir] = @Original_Indir)) AND ((@IsNull_Cap = 1 AND [Cap] IS NULL) OR ([Cap] = @Original_Cap)) AND ((@IsNull_Localita = 1 AND [Localita] IS NULL) OR ([Localita] = @Original_Localita)) AND ((@IsNull_Prov = 1 AND [Prov] IS NULL) OR ([Prov] = @Original_Prov)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note))); SELECT CodCliente, RagSoc, CodFis, Tel, Cell, EnableSMS, Email, Indir, Cap, Localita, Prov, Note FROM AnagClienti WHERE (CodCliente = @CodCliente) dbo.stp_AC_GetByCod dbo.stp_AC_GetLast dbo.stp_AC_upsert SELECT * FROM v_elencoImpegni dbo.stp_Imp_deleteQuery dbo.stp_Imp_getByCodCli dbo.stp_Imp_getByKey dbo.stp_Imp_getBySearch dbo.stp_Imp_getBySearchCronologico dbo.stp_Imp_insertQuery dbo.stp_Imp_recFineInt dbo.stp_Imp_recStartInt dbo.stp_Imp_updateQuery dbo.stp_Imp_updNoteInt dbo.stp_Imp_updStart SELECT Data, NumOp, ScoreDisp, ScoreZona FROM v_DispImpTot dbo.stp_DispImpTot_getByDataRange SELECT Data, CodSquadra, OreDisp, OreImp FROM dbo.v_DispImpSquadre SELECT * FROM dbo.v_ImpegniCal dbo.stp_ImpCal_getByDay DELETE FROM [dbo].[Disponibilita] WHERE (([Data] = @Original_Data) AND ([CodSquadra] = @Original_CodSquadra) AND ([OreDisp] = @Original_OreDisp) AND ([NumOp] = @Original_NumOp) AND ((@IsNull_MinDisp = 1 AND [MinDisp] IS NULL) OR ([MinDisp] = @Original_MinDisp))) INSERT INTO [dbo].[Disponibilita] ([Data], [CodSquadra], [OreDisp], [NumOp]) VALUES (@Data, @CodSquadra, @OreDisp, @NumOp); SELECT Data, CodSquadra, OreDisp, NumOp, MinDisp FROM Disponibilita WHERE (CodSquadra = @CodSquadra) AND (Data = @Data) SELECT Data, CodSquadra, OreDisp, NumOp, MinDisp FROM dbo.Disponibilita UPDATE [dbo].[Disponibilita] SET [Data] = @Data, [CodSquadra] = @CodSquadra, [OreDisp] = @OreDisp, [NumOp] = @NumOp WHERE (([Data] = @Original_Data) AND ([CodSquadra] = @Original_CodSquadra) AND ([OreDisp] = @Original_OreDisp) AND ([NumOp] = @Original_NumOp) AND ((@IsNull_MinDisp = 1 AND [MinDisp] IS NULL) OR ([MinDisp] = @Original_MinDisp))); SELECT Data, CodSquadra, OreDisp, NumOp, MinDisp FROM Disponibilita WHERE (CodSquadra = @CodSquadra) AND (Data = @Data) dbo.stp_Dis_delete dbo.stp_genDispSquadre dbo.stp_genDispSquadreGg dbo.stp_Dis_getByData dbo.stp_Dis_getByDataNumGg SELECT IdxImpegno, NumCons, CodConsegna, DescrConsegna, MinutiStd, NumOp, Elettrod, Clima, Inform, Minuti, Note FROM dbo.v_DettImp dbo.stp_DettImp_delete dbo.stp_DettImp_getByImpegno dbo.stp_DettImp_getByKey dbo.stp_DettImp_insert dbo.stp_DettImp_update SELECT CodCliente, RagSoc, Indir, Cap, Localita, Prov, Zona FROM dbo.v_clientiZone dbo.stp_vcz_search SELECT TIPOPROTOC, NUMERO, ESERPROTOC, NUMEPROTOC, DATAPROTOC, ESERRIFERI, NUMERIFERI, TIPORIFERI, DATARIFERI, NUMEDOCRIF, DATADOCRIF, ESERCOLLEG, CLI_FOR, DESTINATAR, RGSOC_DEST, INDIR_DEST, LOCAL_DEST, CAP_DEST, ULT_AGG, ANNOTAZION FROM raw.DB2_DOCS dbo.stp_DOC_GetByCodCliente dbo.stp_DOC_GetLast dbo.stp_DOC_upsert SELECT DataFrom, CodSquadra, Matr, DataTo, CognomeNome FROM v_AssSqDip dbo.stp_AsSq_delete dbo.stp_AsSq_GetByCodSqData dbo.stp_AsSq_insert DELETE FROM [dbo].[Dipendenti] WHERE (([Matr] = @Original_Matr) AND ([Cognome] = @Original_Cognome) AND ([Nome] = @Original_Nome) AND ([CognomeNome] = @Original_CognomeNome)) INSERT INTO [dbo].[Dipendenti] ([Matr], [Cognome], [Nome]) VALUES (@Matr, @Cognome, @Nome); SELECT Matr, Cognome, Nome, CognomeNome FROM Dipendenti WHERE (Matr = @Matr) SELECT * FROM dbo.Dipendenti UPDATE [dbo].[Dipendenti] SET [Matr] = @Matr, [Cognome] = @Cognome, [Nome] = @Nome WHERE (([Matr] = @Original_Matr) AND ([Cognome] = @Original_Cognome) AND ([Nome] = @Original_Nome) AND ([CognomeNome] = @Original_CognomeNome)); SELECT Matr, Cognome, Nome, CognomeNome FROM Dipendenti WHERE (Matr = @Matr) SELECT IdxImpegno, TotMin FROM dbo.v_resImp dbo.stp_resImp_getByKey SELECT * FROM v_ASSD dbo.stp_ASSD_clonePrevWeek dbo.stp_ASSD_deleteQuery dbo.stp_ASSD_getByImpegno dbo.stp_ASSD_getByDateSlot dbo.stp_ASS_getByDateSlot dbo.stp_ASSD_insMiss dbo.stp_ASSD_updateSquadra