SELECT * FROM v_ST_Actual dbo.stp_ST_A_DeleteQuery dbo.stp_ST_A_getByKey dbo.stp_ST_A_getBySearch dbo.stp_ST_A_InsertQuery dbo.stp_ST_A_updateValid DELETE FROM [dbo].[ST_ActualRows] WHERE (([IdxST] = @Original_IdxST) AND ([Label] = @Original_Label) AND ([Oggetto] = @Original_Oggetto) AND ([Num] = @Original_Num) AND ([CodGruppo] = @Original_CodGruppo) AND ([CodTipo] = @Original_CodTipo) AND ([Value] = @Original_Value) AND ([CheckType] = @Original_CheckType) AND ([Required] = @Original_Required) AND ([Note] = @Original_Note)) INSERT INTO [dbo].[ST_ActualRows] ([IdxST], [Label], [Oggetto], [Num], [CodGruppo], [CodTipo], [Value], [CheckType], [Required], [ExtCode], [Note]) VALUES (@IdxST, @Label, @Oggetto, @Num, @CodGruppo, @CodTipo, @Value, @CheckType, @Required, @ExtCode, @Note); SELECT IdxST, Label, Oggetto, Num, CodGruppo, CodTipo, Value, CheckType, Required, ExtCode, Note FROM ST_ActualRows WHERE (IdxST = @IdxST) AND (Label = @Label) AND (Oggetto = @Oggetto) SELECT DescGruppo, DescTipo, IdxST, Label, Oggetto, Num, CodGruppo, CodTipo, Value, CheckType, Required, ExtCode, Note, ValueRead FROM v_ST_AR UPDATE [dbo].[ST_ActualRows] SET [IdxST] = @IdxST, [Label] = @Label, [Oggetto] = @Oggetto, [Num] = @Num, [CodGruppo] = @CodGruppo, [CodTipo] = @CodTipo, [Value] = @Value, [CheckType] = @CheckType, [Required] = @Required, [ExtCode] = @ExtCode, [Note] = @Note WHERE (([IdxST] = @Original_IdxST) AND ([Label] = @Original_Label) AND ([Oggetto] = @Original_Oggetto) AND ([Num] = @Original_Num) AND ([CodGruppo] = @Original_CodGruppo) AND ([CodTipo] = @Original_CodTipo) AND ([Value] = @Original_Value) AND ([CheckType] = @Original_CheckType) AND ([Required] = @Original_Required) AND ([Note] = @Original_Note)); SELECT IdxST, Label, Oggetto, Num, CodGruppo, CodTipo, Value, CheckType, Required, ExtCode, Note FROM ST_ActualRows WHERE (IdxST = @IdxST) AND (Label = @Label) AND (Oggetto = @Oggetto) dbo.stp_ST_AR_AddByTemplate dbo.stp_ST_AR_deleteQuery dbo.stp_ST_AR_getByGrpIdxST dbo.stp_ST_AR_getByGrpOdl dbo.stp_ST_AR_getGrpOdlLabel dbo.stp_ST_AR_getByIdxST dbo.stp_ST_AR_getPendingOdl dbo.stp_ST_AR_PasteAll dbo.stp_ST_AR_UpdateVal DELETE FROM [ST_Check] WHERE (([DtEvent] = @Original_DtEvent) AND ([IdxODL] = @Original_IdxODL) AND ([IdxST] = @Original_IdxST) AND ([Oggetto] = @Original_Oggetto) AND ([Num] = @Original_Num) AND ([ValueRead] = @Original_ValueRead) AND ([CheckOk] = @Original_CheckOk) AND ([DtMod] = @Original_DtMod) AND ([UserMod] = @Original_UserMod) AND ([Forced] = @Original_Forced)) INSERT INTO [ST_Check] ([DtEvent], [IdxODL], [IdxST], [Oggetto], [Num], [ValueRead], [ExtCode], [CheckOk], [DtMod], [UserMod], [Forced]) VALUES (@DtEvent, @IdxODL, @IdxST, @Oggetto, @Num, @ValueRead, @ExtCode, @CheckOk, @DtMod, @UserMod, @Forced); SELECT DtEvent, IdxODL, IdxST, Oggetto, Num, ValueRead, ExtCode, CheckOk, DtMod, UserMod, Forced FROM ST_Check WHERE (DtEvent = @DtEvent) AND (IdxODL = @IdxODL) AND (IdxST = @IdxST) AND (Num = @Num) AND (Oggetto = @Oggetto) SELECT * FROM ST_Check UPDATE [ST_Check] SET [DtEvent] = @DtEvent, [IdxODL] = @IdxODL, [IdxST] = @IdxST, [Oggetto] = @Oggetto, [Num] = @Num, [ValueRead] = @ValueRead, [ExtCode] = @ExtCode, [CheckOk] = @CheckOk, [DtMod] = @DtMod, [UserMod] = @UserMod, [Forced] = @Forced WHERE (([DtEvent] = @Original_DtEvent) AND ([IdxODL] = @Original_IdxODL) AND ([IdxST] = @Original_IdxST) AND ([Oggetto] = @Original_Oggetto) AND ([Num] = @Original_Num) AND ([ValueRead] = @Original_ValueRead) AND ([CheckOk] = @Original_CheckOk) AND ([DtMod] = @Original_DtMod) AND ([UserMod] = @Original_UserMod) AND ([Forced] = @Original_Forced)); SELECT DtEvent, IdxODL, IdxST, Oggetto, Num, ValueRead, ExtCode, CheckOk, DtMod, UserMod, Forced FROM ST_Check WHERE (DtEvent = @DtEvent) AND (IdxODL = @IdxODL) AND (IdxST = @IdxST) AND (Num = @Num) AND (Oggetto = @Oggetto) dbo.stp_ST_CHK_cleanByOdl dbo.stp_ST_CHK_getByOdl dbo.stp_ST_CHK_upsert DELETE FROM [ST_AnagGruppi] WHERE (([CodGruppo] = @Original_CodGruppo) AND ([DescGruppo] = @Original_DescGruppo) AND ([OrdVisual] = @Original_OrdVisual) AND ([CssClass] = @Original_CssClass)) INSERT INTO [ST_AnagGruppi] ([CodGruppo], [DescGruppo], [OrdVisual], [CssClass]) VALUES (@CodGruppo, @DescGruppo, @OrdVisual, @CssClass); SELECT CodGruppo, DescGruppo, OrdVisual, CssClass FROM ST_AnagGruppi WHERE (CodGruppo = @CodGruppo) ORDER BY OrdVisual SELECT * FROM ST_AnagGruppi ORDER BY OrdVisual UPDATE [ST_AnagGruppi] SET [CodGruppo] = @CodGruppo, [DescGruppo] = @DescGruppo, [OrdVisual] = @OrdVisual, [CssClass] = @CssClass WHERE (([CodGruppo] = @Original_CodGruppo) AND ([DescGruppo] = @Original_DescGruppo) AND ([OrdVisual] = @Original_OrdVisual) AND ([CssClass] = @Original_CssClass)); SELECT CodGruppo, DescGruppo, OrdVisual, CssClass FROM ST_AnagGruppi WHERE (CodGruppo = @CodGruppo) ORDER BY OrdVisual DELETE FROM [dbo].[ST_AnagTipi] WHERE (([CodTipo] = @Original_CodTipo) AND ([DescTipo] = @Original_DescTipo)) INSERT INTO [dbo].[ST_AnagTipi] ([CodTipo], [DescTipo]) VALUES (@CodTipo, @DescTipo); SELECT CodTipo, DescTipo FROM ST_AnagTipi WHERE (CodTipo = @CodTipo) SELECT CodTipo, DescTipo FROM dbo.ST_AnagTipi UPDATE [dbo].[ST_AnagTipi] SET [CodTipo] = @CodTipo, [DescTipo] = @DescTipo WHERE (([CodTipo] = @Original_CodTipo) AND ([DescTipo] = @Original_DescTipo)); SELECT CodTipo, DescTipo FROM ST_AnagTipi WHERE (CodTipo = @CodTipo) DELETE FROM [dbo].[ST_Template] WHERE (([CodTempl] = @Original_CodTempl) AND ([DescTempl] = @Original_DescTempl)) INSERT INTO [dbo].[ST_Template] ([CodTempl], [DescTempl]) VALUES (@CodTempl, @DescTempl); SELECT CodTempl, DescTempl FROM ST_Template WHERE (CodTempl = @CodTempl) SELECT CodTempl, DescTempl FROM dbo.ST_Template UPDATE [dbo].[ST_Template] SET [CodTempl] = @CodTempl, [DescTempl] = @DescTempl WHERE (([CodTempl] = @Original_CodTempl) AND ([DescTempl] = @Original_DescTempl)); SELECT CodTempl, DescTempl FROM ST_Template WHERE (CodTempl = @CodTempl) DELETE FROM [dbo].[ST_TemplateRows] WHERE (([CodTempl] = @Original_CodTempl) AND ([Label] = @Original_Label) AND ([Oggetto] = @Original_Oggetto) AND ([Num] = @Original_Num) AND ([CodGruppo] = @Original_CodGruppo) AND ([CodTipo] = @Original_CodTipo) AND ([Value] = @Original_Value) AND ([CheckType] = @Original_CheckType) AND ([Required] = @Original_Required) AND ([Note] = @Original_Note)) INSERT INTO [dbo].[ST_TemplateRows] ([CodTempl], [Label], [Oggetto], [Num], [CodGruppo], [CodTipo], [Value], [CheckType], [Required], [Note]) VALUES (@CodTempl, @Label, @Oggetto, @Num, @CodGruppo, @CodTipo, @Value, @CheckType, @Required, @Note); SELECT CodTempl, Label, Oggetto, Num, CodGruppo, CodTipo, Value, CheckType, Required, Note FROM ST_TemplateRows WHERE (CodTempl = @CodTempl) AND (Label = @Label) AND (Oggetto = @Oggetto) SELECT CodTempl, Label, Oggetto, Num, CodGruppo, CodTipo, Value, CheckType, Required, Note FROM dbo.ST_TemplateRows UPDATE [dbo].[ST_TemplateRows] SET [CodTempl] = @CodTempl, [Label] = @Label, [Oggetto] = @Oggetto, [Num] = @Num, [CodGruppo] = @CodGruppo, [CodTipo] = @CodTipo, [Value] = @Value, [CheckType] = @CheckType, [Required] = @Required, [Note] = @Note WHERE (([CodTempl] = @Original_CodTempl) AND ([Label] = @Original_Label) AND ([Oggetto] = @Original_Oggetto) AND ([Num] = @Original_Num) AND ([CodGruppo] = @Original_CodGruppo) AND ([CodTipo] = @Original_CodTipo) AND ([Value] = @Original_Value) AND ([CheckType] = @Original_CheckType) AND ([Required] = @Original_Required) AND ([Note] = @Original_Note)); SELECT CodTempl, Label, Oggetto, Num, CodGruppo, CodTipo, Value, CheckType, Required, Note FROM ST_TemplateRows WHERE (CodTempl = @CodTempl) AND (Label = @Label) AND (Oggetto = @Oggetto)