export.stp_TimbratureZucchetti dbo.stp_RA_pivot_getByIdxDipData DELETE FROM [dbo].[ElencoReport] WHERE (([IdxRep] = @Original_IdxRep) AND ([Area] = @Original_Area) AND ((@IsNull_nome = 1 AND [nome] IS NULL) OR ([nome] = @Original_nome)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)) AND ((@IsNull_cssClass = 1 AND [cssClass] IS NULL) OR ([cssClass] = @Original_cssClass)) AND ((@IsNull_ReportUrl = 1 AND [ReportUrl] IS NULL) OR ([ReportUrl] = @Original_ReportUrl))) INSERT INTO [dbo].[ElencoReport] ([Area], [nome], [descrizione], [cssClass], [ReportUrl]) VALUES (@Area, @nome, @descrizione, @cssClass, @ReportUrl); SELECT IdxRep, Area, nome, descrizione, cssClass, ReportUrl FROM ElencoReport WHERE (IdxRep = SCOPE_IDENTITY()) SELECT IdxRep, Area, nome, descrizione, cssClass, ReportUrl FROM dbo.ElencoReport UPDATE [dbo].[ElencoReport] SET [Area] = @Area, [nome] = @nome, [descrizione] = @descrizione, [cssClass] = @cssClass, [ReportUrl] = @ReportUrl WHERE (([IdxRep] = @Original_IdxRep) AND ([Area] = @Original_Area) AND ((@IsNull_nome = 1 AND [nome] IS NULL) OR ([nome] = @Original_nome)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione)) AND ((@IsNull_cssClass = 1 AND [cssClass] IS NULL) OR ([cssClass] = @Original_cssClass)) AND ((@IsNull_ReportUrl = 1 AND [ReportUrl] IS NULL) OR ([ReportUrl] = @Original_ReportUrl))); SELECT IdxRep, Area, nome, descrizione, cssClass, ReportUrl FROM ElencoReport WHERE (IdxRep = @IdxRep) dbo.stp_ER_getByArea