SELECT value, label FROM dbo.v_selClienti dbo.stp_vsc_getBySearchLike dbo.stp_vsc_getByValue SELECT value, label, conditio, Attivo FROM dbo.v_selProgetti dbo.stp_VSPrj_byConditio dbo.stp_VSPrj_byValue dbo.stp_VSPrj SELECT value, label, conditio FROM dbo.v_selCommesse dbo.stp_VSCom_getAttiveBySearchLike dbo.stp_VSCom_getAttiveUnusedBySearchLike dbo.stp_VSCom_byConditio dbo.stp_VSCom_getBySearchLike dbo.stp_VSCom_getByWeek dbo.stp_VSCom_getShortByWeek dbo.stp_VSCom_getShortByIrWeek SELECT label, value FROM dbo.v_selCC ORDER BY label SELECT value, label FROM dbo.v_selCC_all ORDER BY label SELECT n FROM dbo.v_selWeek SELECT n FROM dbo.v_selYear SELECT value, label, conditio FROM dbo.v_selFornitoriCla dbo.stp_VSF_getBySearchLike SELECT NumeroCommessa, AnnoCommessa, Commessa, Emitt, Dest, Tipologia, NrFatt, DataFatt, Importo FROM dbo.v_FattureETS dbo.stp_vFattGetByComm DELETE FROM [dbo].[Storico_DatiCommessa] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_nickname = 1 AND [nickname] IS NULL) OR ([nickname] = @Original_nickname)) AND ((@IsNull_CheckOk = 1 AND [CheckOk] IS NULL) OR ([CheckOk] = @Original_CheckOk)) AND ((@IsNull_CapoCommessa = 1 AND [CapoCommessa] IS NULL) OR ([CapoCommessa] = @Original_CapoCommessa)) AND ((@IsNull_SQC = 1 AND [SQC] IS NULL) OR ([SQC] = @Original_SQC)) AND ((@IsNull_Pubblico = 1 AND [Pubblico] IS NULL) OR ([Pubblico] = @Original_Pubblico)) AND ((@IsNull_EnteProcuratore = 1 AND [EnteProcuratore] IS NULL) OR ([EnteProcuratore] = @Original_EnteProcuratore)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_DataApertura = 1 AND [DataApertura] IS NULL) OR ([DataApertura] = @Original_DataApertura)) AND ((@IsNull_DataScadenza = 1 AND [DataScadenza] IS NULL) OR ([DataScadenza] = @Original_DataScadenza)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_NomeComm = 1 AND [NomeComm] IS NULL) OR ([NomeComm] = @Original_NomeComm)) AND ((@IsNull_ImportoIntegr = 1 AND [ImportoIntegr] IS NULL) OR ([ImportoIntegr] = @Original_ImportoIntegr)) AND ((@IsNull_ImportoFornExt = 1 AND [ImportoFornExt] IS NULL) OR ([ImportoFornExt] = @Original_ImportoFornExt)) AND ((@IsNull_BCWS = 1 AND [BCWS] IS NULL) OR ([BCWS] = @Original_BCWS)) AND ((@IsNull_BCWSFasi = 1 AND [BCWSFasi] IS NULL) OR ([BCWSFasi] = @Original_BCWSFasi)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))) INSERT INTO [dbo].[Storico_DatiCommessa] ([DataEv], [idxFase], [AnnoCommessa], [NumeroCommessa], [nickname], [CheckOk], [CapoCommessa], [SQC], [Pubblico], [EnteProcuratore], [Importo], [DataApertura], [DataScadenza], [rifOfferta], [urlOfferta], [rifOrdine], [urlOrdine], [Indirizzo], [Note], [NomeComm], [ImportoIntegr], [ImportoFornExt], [BCWS], [BCWSFasi], [modificatoDa]) VALUES (@DataEv, @idxFase, @AnnoCommessa, @NumeroCommessa, @nickname, @CheckOk, @CapoCommessa, @SQC, @Pubblico, @EnteProcuratore, @Importo, @DataApertura, @DataScadenza, @rifOfferta, @urlOfferta, @rifOrdine, @urlOrdine, @Indirizzo, @Note, @NomeComm, @ImportoIntegr, @ImportoFornExt, @BCWS, @BCWSFasi, @modificatoDa); SELECT idxEv, DataEv, idxFase, AnnoCommessa, NumeroCommessa, nickname, CheckOk, CapoCommessa, SQC, Pubblico, EnteProcuratore, Importo, DataApertura, DataScadenza, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Indirizzo, Note, NomeComm, ImportoIntegr, ImportoFornExt, BCWS, BCWSFasi, modificatoDa FROM Storico_DatiCommessa WHERE (idxEv = SCOPE_IDENTITY()) SELECT idxEv, DataEv, idxFase, AnnoCommessa, NumeroCommessa, nickname, CheckOk, CapoCommessa, SQC, Pubblico, EnteProcuratore, Importo, DataApertura, DataScadenza, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Indirizzo, Note, NomeComm, ImportoIntegr, ImportoFornExt, BCWS, BCWSFasi, modificatoDa FROM dbo.Storico_DatiCommessa UPDATE [dbo].[Storico_DatiCommessa] SET [DataEv] = @DataEv, [idxFase] = @idxFase, [AnnoCommessa] = @AnnoCommessa, [NumeroCommessa] = @NumeroCommessa, [nickname] = @nickname, [CheckOk] = @CheckOk, [CapoCommessa] = @CapoCommessa, [SQC] = @SQC, [Pubblico] = @Pubblico, [EnteProcuratore] = @EnteProcuratore, [Importo] = @Importo, [DataApertura] = @DataApertura, [DataScadenza] = @DataScadenza, [rifOfferta] = @rifOfferta, [urlOfferta] = @urlOfferta, [rifOrdine] = @rifOrdine, [urlOrdine] = @urlOrdine, [Indirizzo] = @Indirizzo, [Note] = @Note, [NomeComm] = @NomeComm, [ImportoIntegr] = @ImportoIntegr, [ImportoFornExt] = @ImportoFornExt, [BCWS] = @BCWS, [BCWSFasi] = @BCWSFasi, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_AnnoCommessa = 1 AND [AnnoCommessa] IS NULL) OR ([AnnoCommessa] = @Original_AnnoCommessa)) AND ((@IsNull_NumeroCommessa = 1 AND [NumeroCommessa] IS NULL) OR ([NumeroCommessa] = @Original_NumeroCommessa)) AND ((@IsNull_nickname = 1 AND [nickname] IS NULL) OR ([nickname] = @Original_nickname)) AND ((@IsNull_CheckOk = 1 AND [CheckOk] IS NULL) OR ([CheckOk] = @Original_CheckOk)) AND ((@IsNull_CapoCommessa = 1 AND [CapoCommessa] IS NULL) OR ([CapoCommessa] = @Original_CapoCommessa)) AND ((@IsNull_SQC = 1 AND [SQC] IS NULL) OR ([SQC] = @Original_SQC)) AND ((@IsNull_Pubblico = 1 AND [Pubblico] IS NULL) OR ([Pubblico] = @Original_Pubblico)) AND ((@IsNull_EnteProcuratore = 1 AND [EnteProcuratore] IS NULL) OR ([EnteProcuratore] = @Original_EnteProcuratore)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_DataApertura = 1 AND [DataApertura] IS NULL) OR ([DataApertura] = @Original_DataApertura)) AND ((@IsNull_DataScadenza = 1 AND [DataScadenza] IS NULL) OR ([DataScadenza] = @Original_DataScadenza)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Indirizzo = 1 AND [Indirizzo] IS NULL) OR ([Indirizzo] = @Original_Indirizzo)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_NomeComm = 1 AND [NomeComm] IS NULL) OR ([NomeComm] = @Original_NomeComm)) AND ((@IsNull_ImportoIntegr = 1 AND [ImportoIntegr] IS NULL) OR ([ImportoIntegr] = @Original_ImportoIntegr)) AND ((@IsNull_ImportoFornExt = 1 AND [ImportoFornExt] IS NULL) OR ([ImportoFornExt] = @Original_ImportoFornExt)) AND ((@IsNull_BCWS = 1 AND [BCWS] IS NULL) OR ([BCWS] = @Original_BCWS)) AND ((@IsNull_BCWSFasi = 1 AND [BCWSFasi] IS NULL) OR ([BCWSFasi] = @Original_BCWSFasi)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))); SELECT idxEv, DataEv, idxFase, AnnoCommessa, NumeroCommessa, nickname, CheckOk, CapoCommessa, SQC, Pubblico, EnteProcuratore, Importo, DataApertura, DataScadenza, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Indirizzo, Note, NomeComm, ImportoIntegr, ImportoFornExt, BCWS, BCWSFasi, modificatoDa FROM Storico_DatiCommessa WHERE (idxEv = @idxEv) dbo.stp_SDC_getByIdxFase DELETE FROM [dbo].[Storico_DatiCommForn] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCF = 1 AND [idxDCF] IS NULL) OR ([idxDCF] = @Original_idxDCF)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_Fornitore = 1 AND [Fornitore] IS NULL) OR ([Fornitore] = @Original_Fornitore)) AND ((@IsNull_Referente = 1 AND [Referente] IS NULL) OR ([Referente] = @Original_Referente)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOrdineForn = 1 AND [rifOrdineForn] IS NULL) OR ([rifOrdineForn] = @Original_rifOrdineForn)) AND ((@IsNull_urlOrdineForn = 1 AND [urlOrdineForn] IS NULL) OR ([urlOrdineForn] = @Original_urlOrdineForn)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))) INSERT INTO [dbo].[Storico_DatiCommForn] ([DataEv], [idxDCF], [idxFase], [Fornitore], [Referente], [Importo], [rifOrdineForn], [urlOrdineForn], [Note], [modificatoDa]) VALUES (@DataEv, @idxDCF, @idxFase, @Fornitore, @Referente, @Importo, @rifOrdineForn, @urlOrdineForn, @Note, @modificatoDa); SELECT idxEv, DataEv, idxDCF, idxFase, Fornitore, Referente, Importo, rifOrdineForn, urlOrdineForn, Note, modificatoDa FROM Storico_DatiCommForn WHERE (idxEv = SCOPE_IDENTITY()) SELECT idxEv, DataEv, idxDCF, idxFase, Fornitore, Referente, Importo, rifOrdineForn, urlOrdineForn, Note, modificatoDa FROM dbo.Storico_DatiCommForn UPDATE [dbo].[Storico_DatiCommForn] SET [DataEv] = @DataEv, [idxDCF] = @idxDCF, [idxFase] = @idxFase, [Fornitore] = @Fornitore, [Referente] = @Referente, [Importo] = @Importo, [rifOrdineForn] = @rifOrdineForn, [urlOrdineForn] = @urlOrdineForn, [Note] = @Note, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCF = 1 AND [idxDCF] IS NULL) OR ([idxDCF] = @Original_idxDCF)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_Fornitore = 1 AND [Fornitore] IS NULL) OR ([Fornitore] = @Original_Fornitore)) AND ((@IsNull_Referente = 1 AND [Referente] IS NULL) OR ([Referente] = @Original_Referente)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOrdineForn = 1 AND [rifOrdineForn] IS NULL) OR ([rifOrdineForn] = @Original_rifOrdineForn)) AND ((@IsNull_urlOrdineForn = 1 AND [urlOrdineForn] IS NULL) OR ([urlOrdineForn] = @Original_urlOrdineForn)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))); SELECT idxEv, DataEv, idxDCF, idxFase, Fornitore, Referente, Importo, rifOrdineForn, urlOrdineForn, Note, modificatoDa FROM Storico_DatiCommForn WHERE (idxEv = @idxEv) dbo.stp_SDCF_getByIdxFase DELETE FROM [dbo].[Storico_DatiCommInteg] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCI = 1 AND [idxDCI] IS NULL) OR ([idxDCI] = @Original_idxDCI)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))) INSERT INTO [dbo].[Storico_DatiCommInteg] ([DataEv], [idxDCI], [idxFase], [DataRif], [Importo], [rifOfferta], [urlOfferta], [rifOrdine], [urlOrdine], [Note], [modificatoDa]) VALUES (@DataEv, @idxDCI, @idxFase, @DataRif, @Importo, @rifOfferta, @urlOfferta, @rifOrdine, @urlOrdine, @Note, @modificatoDa); SELECT idxEv, DataEv, idxDCI, idxFase, DataRif, Importo, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Note, modificatoDa FROM Storico_DatiCommInteg WHERE (idxEv = SCOPE_IDENTITY()) SELECT idxEv, DataEv, idxDCI, idxFase, DataRif, Importo, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Note, modificatoDa FROM dbo.Storico_DatiCommInteg UPDATE [dbo].[Storico_DatiCommInteg] SET [DataEv] = @DataEv, [idxDCI] = @idxDCI, [idxFase] = @idxFase, [DataRif] = @DataRif, [Importo] = @Importo, [rifOfferta] = @rifOfferta, [urlOfferta] = @urlOfferta, [rifOrdine] = @rifOrdine, [urlOrdine] = @urlOrdine, [Note] = @Note, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxDCI = 1 AND [idxDCI] IS NULL) OR ([idxDCI] = @Original_idxDCI)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_Importo = 1 AND [Importo] IS NULL) OR ([Importo] = @Original_Importo)) AND ((@IsNull_rifOfferta = 1 AND [rifOfferta] IS NULL) OR ([rifOfferta] = @Original_rifOfferta)) AND ((@IsNull_urlOfferta = 1 AND [urlOfferta] IS NULL) OR ([urlOfferta] = @Original_urlOfferta)) AND ((@IsNull_rifOrdine = 1 AND [rifOrdine] IS NULL) OR ([rifOrdine] = @Original_rifOrdine)) AND ((@IsNull_urlOrdine = 1 AND [urlOrdine] IS NULL) OR ([urlOrdine] = @Original_urlOrdine)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))); SELECT idxEv, DataEv, idxDCI, idxFase, DataRif, Importo, rifOfferta, urlOfferta, rifOrdine, urlOrdine, Note, modificatoDa FROM Storico_DatiCommInteg WHERE (idxEv = @idxEv) dbo.stp_SDCI_getByIdxFase DELETE FROM [dbo].[Storico_DatiFase] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataScad = 1 AND [DataScad] IS NULL) OR ([DataScad] = @Original_DataScad)) AND ((@IsNull_ScadFixed = 1 AND [ScadFixed] IS NULL) OR ([ScadFixed] = @Original_ScadFixed)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))) INSERT INTO [dbo].[Storico_DatiFase] ([DataEv], [idxFase], [DataScad], [ScadFixed], [Note], [modificatoDa]) VALUES (@DataEv, @idxFase, @DataScad, @ScadFixed, @Note, @modificatoDa); SELECT idxEv, DataEv, idxFase, DataScad, ScadFixed, Note, modificatoDa FROM Storico_DatiFase WHERE (idxEv = SCOPE_IDENTITY()) SELECT idxEv, DataEv, idxFase, DataScad, ScadFixed, Note, modificatoDa FROM dbo.Storico_DatiFase UPDATE [dbo].[Storico_DatiFase] SET [DataEv] = @DataEv, [idxFase] = @idxFase, [DataScad] = @DataScad, [ScadFixed] = @ScadFixed, [Note] = @Note, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_DataScad = 1 AND [DataScad] IS NULL) OR ([DataScad] = @Original_DataScad)) AND ((@IsNull_ScadFixed = 1 AND [ScadFixed] IS NULL) OR ([ScadFixed] = @Original_ScadFixed)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))); SELECT idxEv, DataEv, idxFase, DataScad, ScadFixed, Note, modificatoDa FROM Storico_DatiFase WHERE (idxEv = @idxEv) dbo.stp_SDF_getByIdxFase DELETE FROM [dbo].[Storico_BdgtRisorseFasi] WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_CodTipoRisorsa = 1 AND [CodTipoRisorsa] IS NULL) OR ([CodTipoRisorsa] = @Original_CodTipoRisorsa)) AND ((@IsNull_OreBdgt = 1 AND [OreBdgt] IS NULL) OR ([OreBdgt] = @Original_OreBdgt)) AND ((@IsNull_CostoBdgt = 1 AND [CostoBdgt] IS NULL) OR ([CostoBdgt] = @Original_CostoBdgt)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))) INSERT INTO [dbo].[Storico_BdgtRisorseFasi] ([DataEv], [idxFase], [CodTipoRisorsa], [OreBdgt], [CostoBdgt], [DataRif], [modificatoDa]) VALUES (@DataEv, @idxFase, @CodTipoRisorsa, @OreBdgt, @CostoBdgt, @DataRif, @modificatoDa); SELECT idxEv, DataEv, idxFase, CodTipoRisorsa, OreBdgt, CostoBdgt, DataRif, modificatoDa FROM Storico_BdgtRisorseFasi WHERE (idxEv = SCOPE_IDENTITY()) SELECT idxEv, DataEv, idxFase, CodTipoRisorsa, OreBdgt, CostoBdgt, DataRif, modificatoDa FROM dbo.Storico_BdgtRisorseFasi UPDATE [dbo].[Storico_BdgtRisorseFasi] SET [DataEv] = @DataEv, [idxFase] = @idxFase, [CodTipoRisorsa] = @CodTipoRisorsa, [OreBdgt] = @OreBdgt, [CostoBdgt] = @CostoBdgt, [DataRif] = @DataRif, [modificatoDa] = @modificatoDa WHERE (([idxEv] = @Original_idxEv) AND ((@IsNull_DataEv = 1 AND [DataEv] IS NULL) OR ([DataEv] = @Original_DataEv)) AND ((@IsNull_idxFase = 1 AND [idxFase] IS NULL) OR ([idxFase] = @Original_idxFase)) AND ((@IsNull_CodTipoRisorsa = 1 AND [CodTipoRisorsa] IS NULL) OR ([CodTipoRisorsa] = @Original_CodTipoRisorsa)) AND ((@IsNull_OreBdgt = 1 AND [OreBdgt] IS NULL) OR ([OreBdgt] = @Original_OreBdgt)) AND ((@IsNull_CostoBdgt = 1 AND [CostoBdgt] IS NULL) OR ([CostoBdgt] = @Original_CostoBdgt)) AND ((@IsNull_DataRif = 1 AND [DataRif] IS NULL) OR ([DataRif] = @Original_DataRif)) AND ((@IsNull_modificatoDa = 1 AND [modificatoDa] IS NULL) OR ([modificatoDa] = @Original_modificatoDa))); SELECT idxEv, DataEv, idxFase, CodTipoRisorsa, OreBdgt, CostoBdgt, DataRif, modificatoDa FROM Storico_BdgtRisorseFasi WHERE (idxEv = @idxEv) dbo.stp_SBRF_getByIdxFase