DELETE FROM [dbo].[AnnotationAudits] WHERE (([AuditID] = @Original_AuditID) AND ([AnnotationID] = @Original_AnnotationID) AND ([ItemID] = @Original_ItemID) AND ([TypeID] = @Original_TypeID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus) AND ((@IsNull_ActionDTS = 1 AND [ActionDTS] IS NULL) OR ([ActionDTS] = @Original_ActionDTS))) INSERT INTO [dbo].[AnnotationAudits] ([AnnotationID], [ItemID], [TypeID], [RtfText], [SearchText], [Config], [DTS], [UserID], [DeleteStatus], [ActionDTS]) VALUES (@AnnotationID, @ItemID, @TypeID, @RtfText, @SearchText, @Config, @DTS, @UserID, @DeleteStatus, @ActionDTS); SELECT AuditID, AnnotationID, ItemID, TypeID, RtfText, SearchText, Config, DTS, UserID, DeleteStatus, ActionDTS FROM AnnotationAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, AnnotationID, ItemID, TypeID, RtfText, SearchText, Config, DTS, UserID, DeleteStatus, ActionDTS FROM dbo.AnnotationAudits UPDATE [dbo].[AnnotationAudits] SET [AnnotationID] = @AnnotationID, [ItemID] = @ItemID, [TypeID] = @TypeID, [RtfText] = @RtfText, [SearchText] = @SearchText, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus, [ActionDTS] = @ActionDTS WHERE (([AuditID] = @Original_AuditID) AND ([AnnotationID] = @Original_AnnotationID) AND ([ItemID] = @Original_ItemID) AND ([TypeID] = @Original_TypeID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus) AND ((@IsNull_ActionDTS = 1 AND [ActionDTS] IS NULL) OR ([ActionDTS] = @Original_ActionDTS))); SELECT AuditID, AnnotationID, ItemID, TypeID, RtfText, SearchText, Config, DTS, UserID, DeleteStatus, ActionDTS FROM AnnotationAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[AnnotationTypes] WHERE (([TypeID] = @Original_TypeID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[AnnotationTypes] ([Name], [Config], [DTS], [UserID]) VALUES (@Name, @Config, @DTS, @UserID); SELECT TypeID, Name, Config, DTS, UserID, LastChanged FROM AnnotationTypes WHERE (TypeID = SCOPE_IDENTITY()) SELECT TypeID, Name, Config, DTS, UserID, LastChanged FROM dbo.AnnotationTypes UPDATE [dbo].[AnnotationTypes] SET [Name] = @Name, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([TypeID] = @Original_TypeID) AND ([LastChanged] = @Original_LastChanged)); SELECT TypeID, Name, Config, DTS, UserID, LastChanged FROM AnnotationTypes WHERE (TypeID = @TypeID) DELETE FROM [dbo].[ApplicableStructures] WHERE (([StructureID] = @Original_StructureID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[ApplicableStructures] ([StructureID], [AppItems], [DTS], [UserID]) VALUES (@StructureID, @AppItems, @DTS, @UserID); SELECT StructureID, AppItems, DTS, UserID, LastChanged FROM ApplicableStructures WHERE (StructureID = @StructureID) SELECT StructureID, AppItems, DTS, UserID, LastChanged FROM dbo.ApplicableStructures UPDATE [dbo].[ApplicableStructures] SET [StructureID] = @StructureID, [AppItems] = @AppItems, [DTS] = @DTS, [UserID] = @UserID WHERE (([StructureID] = @Original_StructureID) AND ([LastChanged] = @Original_LastChanged)); SELECT StructureID, AppItems, DTS, UserID, LastChanged FROM ApplicableStructures WHERE (StructureID = @StructureID) DELETE FROM [dbo].[Assignments] WHERE (([AID] = @Original_AID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Assignments] ([GID], [RID], [FolderID], [StartDate], [EndDate], [DTS], [UsrID]) VALUES (@GID, @RID, @FolderID, @StartDate, @EndDate, @DTS, @UsrID); SELECT AID, GID, RID, FolderID, StartDate, EndDate, DTS, UsrID, LastChanged FROM Assignments WHERE (AID = SCOPE_IDENTITY()) SELECT AID, GID, RID, FolderID, StartDate, EndDate, DTS, UsrID, LastChanged FROM dbo.Assignments UPDATE [dbo].[Assignments] SET [GID] = @GID, [RID] = @RID, [FolderID] = @FolderID, [StartDate] = @StartDate, [EndDate] = @EndDate, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([AID] = @Original_AID) AND ([LastChanged] = @Original_LastChanged)); SELECT AID, GID, RID, FolderID, StartDate, EndDate, DTS, UsrID, LastChanged FROM Assignments WHERE (AID = @AID) DELETE FROM [dbo].[Associations] WHERE (([AssociationID] = @Original_AssociationID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Associations] ([VersionID], [ROFstID], [Config], [DTS], [UserID]) VALUES (@VersionID, @ROFstID, @Config, @DTS, @UserID); SELECT AssociationID, VersionID, ROFstID, Config, DTS, UserID, LastChanged FROM Associations WHERE (AssociationID = SCOPE_IDENTITY()) SELECT AssociationID, VersionID, ROFstID, Config, DTS, UserID, LastChanged FROM dbo.Associations UPDATE [dbo].[Associations] SET [VersionID] = @VersionID, [ROFstID] = @ROFstID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([AssociationID] = @Original_AssociationID) AND ([LastChanged] = @Original_LastChanged)); SELECT AssociationID, VersionID, ROFstID, Config, DTS, UserID, LastChanged FROM Associations WHERE (AssociationID = @AssociationID) DELETE FROM [dbo].[Branches] WHERE (([BranchID] = @Original_BranchID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Branches] ([VersionID], [DateLimit], [BeforeType], [BeforeID], [AfterType], [AfterID]) VALUES (@VersionID, @DateLimit, @BeforeType, @BeforeID, @AfterType, @AfterID); SELECT BranchID, VersionID, DateLimit, BeforeType, BeforeID, AfterType, AfterID, LastChanged FROM Branches WHERE (BranchID = SCOPE_IDENTITY()) SELECT BranchID, VersionID, DateLimit, BeforeType, BeforeID, AfterType, AfterID, LastChanged FROM dbo.Branches UPDATE [dbo].[Branches] SET [VersionID] = @VersionID, [DateLimit] = @DateLimit, [BeforeType] = @BeforeType, [BeforeID] = @BeforeID, [AfterType] = @AfterType, [AfterID] = @AfterID WHERE (([BranchID] = @Original_BranchID) AND ([LastChanged] = @Original_LastChanged)); SELECT BranchID, VersionID, DateLimit, BeforeType, BeforeID, AfterType, AfterID, LastChanged FROM Branches WHERE (BranchID = @BranchID) DELETE FROM [dbo].[Checks] WHERE (([CheckID] = @Original_CheckID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Checks] ([RevisionID], [StageID], [ConsistencyChecks], [DTS], [UserID]) VALUES (@RevisionID, @StageID, @ConsistencyChecks, @DTS, @UserID); SELECT CheckID, RevisionID, StageID, ConsistencyChecks, DTS, UserID, LastChanged FROM Checks WHERE (CheckID = SCOPE_IDENTITY()) SELECT CheckID, RevisionID, StageID, ConsistencyChecks, DTS, UserID, LastChanged FROM dbo.Checks UPDATE [dbo].[Checks] SET [RevisionID] = @RevisionID, [StageID] = @StageID, [ConsistencyChecks] = @ConsistencyChecks, [DTS] = @DTS, [UserID] = @UserID WHERE (([CheckID] = @Original_CheckID) AND ([LastChanged] = @Original_LastChanged)); SELECT CheckID, RevisionID, StageID, ConsistencyChecks, DTS, UserID, LastChanged FROM Checks WHERE (CheckID = @CheckID) DELETE FROM [dbo].[Connections] WHERE (([DBID] = @Original_DBID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Connections] ([Name], [Title], [ConnectionString], [ServerType], [Config], [DTS], [UsrID]) VALUES (@Name, @Title, @ConnectionString, @ServerType, @Config, @DTS, @UsrID); SELECT DBID, Name, Title, ConnectionString, ServerType, Config, DTS, UsrID, LastChanged FROM Connections WHERE (DBID = SCOPE_IDENTITY()) SELECT DBID, Name, Title, ConnectionString, ServerType, Config, DTS, UsrID, LastChanged FROM dbo.Connections UPDATE [dbo].[Connections] SET [Name] = @Name, [Title] = @Title, [ConnectionString] = @ConnectionString, [ServerType] = @ServerType, [Config] = @Config, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([DBID] = @Original_DBID) AND ([LastChanged] = @Original_LastChanged)); SELECT DBID, Name, Title, ConnectionString, ServerType, Config, DTS, UsrID, LastChanged FROM Connections WHERE (DBID = @DBID) DELETE FROM [dbo].[ContentAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ((@IsNull_Number = 1 AND [Number] IS NULL) OR ([Number] = @Original_Number)) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_FormatID = 1 AND [FormatID] IS NULL) OR ([FormatID] = @Original_FormatID)) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus) AND ((@IsNull_ActionDTS = 1 AND [ActionDTS] IS NULL) OR ([ActionDTS] = @Original_ActionDTS))) INSERT INTO [dbo].[ContentAudits] ([ContentID], [Number], [Text], [Type], [FormatID], [Config], [DTS], [UserID], [DeleteStatus], [ActionDTS]) VALUES (@ContentID, @Number, @Text, @Type, @FormatID, @Config, @DTS, @UserID, @DeleteStatus, @ActionDTS); SELECT AuditID, ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, DeleteStatus, ActionDTS FROM ContentAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, DeleteStatus, ActionDTS FROM dbo.ContentAudits UPDATE [dbo].[ContentAudits] SET [ContentID] = @ContentID, [Number] = @Number, [Text] = @Text, [Type] = @Type, [FormatID] = @FormatID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus, [ActionDTS] = @ActionDTS WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ((@IsNull_Number = 1 AND [Number] IS NULL) OR ([Number] = @Original_Number)) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_FormatID = 1 AND [FormatID] IS NULL) OR ([FormatID] = @Original_FormatID)) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus) AND ((@IsNull_ActionDTS = 1 AND [ActionDTS] IS NULL) OR ([ActionDTS] = @Original_ActionDTS))); SELECT AuditID, ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, DeleteStatus, ActionDTS FROM ContentAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[DeleteLog] WHERE (([DeleteID] = @Original_DeleteID) AND ([SPID] = @Original_SPID) AND ([UserID] = @Original_UserID) AND ([DTS] = @Original_DTS)) INSERT INTO [dbo].[DeleteLog] ([SPID], [UserID], [DTS]) VALUES (@SPID, @UserID, @DTS); SELECT DeleteID, SPID, UserID, DTS FROM DeleteLog WHERE (DeleteID = SCOPE_IDENTITY()) SELECT DeleteID, SPID, UserID, DTS FROM dbo.DeleteLog UPDATE [dbo].[DeleteLog] SET [SPID] = @SPID, [UserID] = @UserID, [DTS] = @DTS WHERE (([DeleteID] = @Original_DeleteID) AND ([SPID] = @Original_SPID) AND ([UserID] = @Original_UserID) AND ([DTS] = @Original_DTS)); SELECT DeleteID, SPID, UserID, DTS FROM DeleteLog WHERE (DeleteID = @DeleteID) DELETE FROM [dbo].[Details] WHERE (([DetailID] = @Original_DetailID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Details] ([ContentID], [ItemType], [Text], [Config], [DTS], [UserID]) VALUES (@ContentID, @ItemType, @Text, @Config, @DTS, @UserID); SELECT DetailID, ContentID, ItemType, Text, Config, DTS, UserID, LastChanged FROM Details WHERE (DetailID = SCOPE_IDENTITY()) SELECT DetailID, ContentID, ItemType, Text, Config, DTS, UserID, LastChanged FROM dbo.Details UPDATE [dbo].[Details] SET [ContentID] = @ContentID, [ItemType] = @ItemType, [Text] = @Text, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([DetailID] = @Original_DetailID) AND ([LastChanged] = @Original_LastChanged)); SELECT DetailID, ContentID, ItemType, Text, Config, DTS, UserID, LastChanged FROM Details WHERE (DetailID = @DetailID) DELETE FROM [dbo].[DocumentAudits] WHERE (([AuditID] = @Original_AuditID) AND ([DocID] = @Original_DocID) AND ((@IsNull_LibTitle = 1 AND [LibTitle] IS NULL) OR ([LibTitle] = @Original_LibTitle)) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([FileExtension] = @Original_FileExtension) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[DocumentAudits] ([DocID], [LibTitle], [DocContent], [DocAscii], [Config], [DTS], [UserID], [FileExtension], [DeleteStatus]) VALUES (@DocID, @LibTitle, @DocContent, @DocAscii, @Config, @DTS, @UserID, @FileExtension, @DeleteStatus); SELECT AuditID, DocID, LibTitle, DocContent, DocAscii, Config, DTS, UserID, FileExtension, DeleteStatus FROM DocumentAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, DocID, LibTitle, DocContent, DocAscii, Config, DTS, UserID, FileExtension, DeleteStatus FROM dbo.DocumentAudits UPDATE [dbo].[DocumentAudits] SET [DocID] = @DocID, [LibTitle] = @LibTitle, [DocContent] = @DocContent, [DocAscii] = @DocAscii, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [FileExtension] = @FileExtension, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([DocID] = @Original_DocID) AND ((@IsNull_LibTitle = 1 AND [LibTitle] IS NULL) OR ([LibTitle] = @Original_LibTitle)) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([FileExtension] = @Original_FileExtension) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, DocID, LibTitle, DocContent, DocAscii, Config, DTS, UserID, FileExtension, DeleteStatus FROM DocumentAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[DocVersions] WHERE (([VersionID] = @Original_VersionID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[DocVersions] ([FolderID], [VersionType], [Name], [Title], [ItemID], [FormatID], [Config], [DTS], [UserID]) VALUES (@FolderID, @VersionType, @Name, @Title, @ItemID, @FormatID, @Config, @DTS, @UserID); SELECT VersionID, FolderID, VersionType, Name, Title, ItemID, FormatID, Config, DTS, UserID, LastChanged FROM DocVersions WHERE (VersionID = SCOPE_IDENTITY()) SELECT VersionID, FolderID, VersionType, Name, Title, ItemID, FormatID, Config, DTS, UserID, LastChanged FROM dbo.DocVersions UPDATE [dbo].[DocVersions] SET [FolderID] = @FolderID, [VersionType] = @VersionType, [Name] = @Name, [Title] = @Title, [ItemID] = @ItemID, [FormatID] = @FormatID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([VersionID] = @Original_VersionID) AND ([LastChanged] = @Original_LastChanged)); SELECT VersionID, FolderID, VersionType, Name, Title, ItemID, FormatID, Config, DTS, UserID, LastChanged FROM DocVersions WHERE (VersionID = @VersionID) DELETE FROM [dbo].[DROUsages] WHERE (([DROUsageID] = @Original_DROUsageID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[DROUsages] ([DocID], [ROID], [Config], [DTS], [UserID], [RODbID]) VALUES (@DocID, @ROID, @Config, @DTS, @UserID, @RODbID); SELECT DROUsageID, DocID, ROID, Config, DTS, UserID, LastChanged, RODbID FROM DROUsages WHERE (DROUsageID = SCOPE_IDENTITY()) SELECT DROUsageID, DocID, ROID, Config, DTS, UserID, LastChanged, RODbID FROM dbo.DROUsages UPDATE [dbo].[DROUsages] SET [DocID] = @DocID, [ROID] = @ROID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [RODbID] = @RODbID WHERE (([DROUsageID] = @Original_DROUsageID) AND ([LastChanged] = @Original_LastChanged)); SELECT DROUsageID, DocID, ROID, Config, DTS, UserID, LastChanged, RODbID FROM DROUsages WHERE (DROUsageID = @DROUsageID) DELETE FROM [dbo].[EntryAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([DocID] = @Original_DocID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[EntryAudits] ([ContentID], [DocID], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @DocID, @DTS, @UserID, @DeleteStatus); SELECT AuditID, ContentID, DocID, DTS, UserID, DeleteStatus FROM EntryAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ContentID, DocID, DTS, UserID, DeleteStatus FROM dbo.EntryAudits UPDATE [dbo].[EntryAudits] SET [ContentID] = @ContentID, [DocID] = @DocID, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([DocID] = @Original_DocID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, ContentID, DocID, DTS, UserID, DeleteStatus FROM EntryAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[Figures] WHERE (([FigureID] = @Original_FigureID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Figures] ([ROFstID], [ImageID], [Config], [DTS], [UserID]) VALUES (@ROFstID, @ImageID, @Config, @DTS, @UserID); SELECT FigureID, ROFstID, ImageID, Config, DTS, UserID, LastChanged FROM Figures WHERE (FigureID = SCOPE_IDENTITY()) SELECT FigureID, ROFstID, ImageID, Config, DTS, UserID, LastChanged FROM dbo.Figures UPDATE [dbo].[Figures] SET [ROFstID] = @ROFstID, [ImageID] = @ImageID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([FigureID] = @Original_FigureID) AND ([LastChanged] = @Original_LastChanged)); SELECT FigureID, ROFstID, ImageID, Config, DTS, UserID, LastChanged FROM Figures WHERE (FigureID = @FigureID) DELETE FROM [dbo].[Folders] WHERE (([FolderID] = @Original_FolderID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Folders] ([ParentID], [DBID], [Name], [Title], [ShortName], [FormatID], [ManualOrder], [Config], [DTS], [UsrID]) VALUES (@ParentID, @DBID, @Name, @Title, @ShortName, @FormatID, @ManualOrder, @Config, @DTS, @UsrID); SELECT FolderID, ParentID, DBID, Name, Title, ShortName, FormatID, ManualOrder, Config, DTS, UsrID, LastChanged FROM Folders WHERE (FolderID = SCOPE_IDENTITY()) SELECT FolderID, ParentID, DBID, Name, Title, ShortName, FormatID, ManualOrder, Config, DTS, UsrID, LastChanged FROM dbo.Folders UPDATE [dbo].[Folders] SET [ParentID] = @ParentID, [DBID] = @DBID, [Name] = @Name, [Title] = @Title, [ShortName] = @ShortName, [FormatID] = @FormatID, [ManualOrder] = @ManualOrder, [Config] = @Config, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([FolderID] = @Original_FolderID) AND ([LastChanged] = @Original_LastChanged)); SELECT FolderID, ParentID, DBID, Name, Title, ShortName, FormatID, ManualOrder, Config, DTS, UsrID, LastChanged FROM Folders WHERE (FolderID = @FolderID) DELETE FROM [dbo].[Formats] WHERE (([FormatID] = @Original_FormatID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Formats] ([ParentID], [Name], [Description], [Data], [GenMac], [DTS], [UserID], [Config], [ApplicablePlant]) VALUES (@ParentID, @Name, @Description, @Data, @GenMac, @DTS, @UserID, @Config, @ApplicablePlant); SELECT FormatID, ParentID, Name, Description, Data, GenMac, DTS, UserID, LastChanged, Config, ApplicablePlant FROM Formats WHERE (FormatID = SCOPE_IDENTITY()) SELECT FormatID, ParentID, Name, Description, Data, GenMac, DTS, UserID, LastChanged, Config, ApplicablePlant FROM dbo.Formats UPDATE [dbo].[Formats] SET [ParentID] = @ParentID, [Name] = @Name, [Description] = @Description, [Data] = @Data, [GenMac] = @GenMac, [DTS] = @DTS, [UserID] = @UserID, [Config] = @Config, [ApplicablePlant] = @ApplicablePlant WHERE (([FormatID] = @Original_FormatID) AND ([LastChanged] = @Original_LastChanged)); SELECT FormatID, ParentID, Name, Description, Data, GenMac, DTS, UserID, LastChanged, Config, ApplicablePlant FROM Formats WHERE (FormatID = @FormatID) DELETE FROM [dbo].[GridAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus) AND ([ContentAuditID] = @Original_ContentAuditID)) INSERT INTO [dbo].[GridAudits] ([ContentID], [Data], [Config], [DTS], [UserID], [DeleteStatus], [ContentAuditID]) VALUES (@ContentID, @Data, @Config, @DTS, @UserID, @DeleteStatus, @ContentAuditID); SELECT AuditID, ContentID, Data, Config, DTS, UserID, DeleteStatus, ContentAuditID FROM GridAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ContentID, Data, Config, DTS, UserID, DeleteStatus, ContentAuditID FROM dbo.GridAudits UPDATE [dbo].[GridAudits] SET [ContentID] = @ContentID, [Data] = @Data, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus, [ContentAuditID] = @ContentAuditID WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus) AND ([ContentAuditID] = @Original_ContentAuditID)); SELECT AuditID, ContentID, Data, Config, DTS, UserID, DeleteStatus, ContentAuditID FROM GridAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[Groups] WHERE (([GID] = @Original_GID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Groups] ([GroupName], [GroupType], [Config], [DTS], [UsrID]) VALUES (@GroupName, @GroupType, @Config, @DTS, @UsrID); SELECT GID, GroupName, GroupType, Config, DTS, UsrID, LastChanged FROM Groups WHERE (GID = SCOPE_IDENTITY()) SELECT GID, GroupName, GroupType, Config, DTS, UsrID, LastChanged FROM dbo.Groups UPDATE [dbo].[Groups] SET [GroupName] = @GroupName, [GroupType] = @GroupType, [Config] = @Config, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([GID] = @Original_GID) AND ([LastChanged] = @Original_LastChanged)); SELECT GID, GroupName, GroupType, Config, DTS, UsrID, LastChanged FROM Groups WHERE (GID = @GID) DELETE FROM [dbo].[ImageAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([ImageType] = @Original_ImageType) AND ([FileName] = @Original_FileName) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[ImageAudits] ([ContentID], [ImageType], [FileName], [Data], [Config], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @ImageType, @FileName, @Data, @Config, @DTS, @UserID, @DeleteStatus); SELECT AuditID, ContentID, ImageType, FileName, Data, Config, DTS, UserID, DeleteStatus FROM ImageAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ContentID, ImageType, FileName, Data, Config, DTS, UserID, DeleteStatus FROM dbo.ImageAudits UPDATE [dbo].[ImageAudits] SET [ContentID] = @ContentID, [ImageType] = @ImageType, [FileName] = @FileName, [Data] = @Data, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([ImageType] = @Original_ImageType) AND ([FileName] = @Original_FileName) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, ContentID, ImageType, FileName, Data, Config, DTS, UserID, DeleteStatus FROM ImageAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[ItemAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ItemID] = @Original_ItemID) AND ((@IsNull_PreviousID = 1 AND [PreviousID] IS NULL) OR ([PreviousID] = @Original_PreviousID)) AND ([ContentID] = @Original_ContentID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[ItemAudits] ([ItemID], [PreviousID], [ContentID], [DTS], [UserID], [DeleteStatus]) VALUES (@ItemID, @PreviousID, @ContentID, @DTS, @UserID, @DeleteStatus); SELECT AuditID, ItemID, PreviousID, ContentID, DTS, UserID, DeleteStatus FROM ItemAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ItemID, PreviousID, ContentID, DTS, UserID, DeleteStatus FROM dbo.ItemAudits UPDATE [dbo].[ItemAudits] SET [ItemID] = @ItemID, [PreviousID] = @PreviousID, [ContentID] = @ContentID, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([ItemID] = @Original_ItemID) AND ((@IsNull_PreviousID = 1 AND [PreviousID] IS NULL) OR ([PreviousID] = @Original_PreviousID)) AND ([ContentID] = @Original_ContentID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, ItemID, PreviousID, ContentID, DTS, UserID, DeleteStatus FROM ItemAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[Locks] WHERE (([LockID] = @Original_LockID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Locks] ([UserID], [LockType], [LockItemID], [Description], [DTS]) VALUES (@UserID, @LockType, @LockItemID, @Description, @DTS); SELECT LockID, UserID, LockType, LockItemID, Description, DTS, LastChanged FROM Locks WHERE (LockID = SCOPE_IDENTITY()) SELECT LockID, UserID, LockType, LockItemID, Description, DTS, LastChanged FROM dbo.Locks UPDATE [dbo].[Locks] SET [UserID] = @UserID, [LockType] = @LockType, [LockItemID] = @LockItemID, [Description] = @Description, [DTS] = @DTS WHERE (([LockID] = @Original_LockID) AND ([LastChanged] = @Original_LastChanged)); SELECT LockID, UserID, LockType, LockItemID, Description, DTS, LastChanged FROM Locks WHERE (LockID = @LockID) DELETE FROM [dbo].[Memberships] WHERE (([UGID] = @Original_UGID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Memberships] ([UID], [GID], [StartDate], [EndDate], [Config], [DTS], [UsrID]) VALUES (@UID, @GID, @StartDate, @EndDate, @Config, @DTS, @UsrID); SELECT UGID, UID, GID, StartDate, EndDate, Config, DTS, UsrID, LastChanged FROM Memberships WHERE (UGID = SCOPE_IDENTITY()) SELECT UGID, UID, GID, StartDate, EndDate, Config, DTS, UsrID, LastChanged FROM dbo.Memberships UPDATE [dbo].[Memberships] SET [UID] = @UID, [GID] = @GID, [StartDate] = @StartDate, [EndDate] = @EndDate, [Config] = @Config, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([UGID] = @Original_UGID) AND ([LastChanged] = @Original_LastChanged)); SELECT UGID, UID, GID, StartDate, EndDate, Config, DTS, UsrID, LastChanged FROM Memberships WHERE (UGID = @UGID) DELETE FROM [dbo].[Owners] WHERE (([OwnerID] = @Original_OwnerID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Owners] ([SessionID], [OwnerType], [OwnerItemID], [DTSStart]) VALUES (@SessionID, @OwnerType, @OwnerItemID, @DTSStart); SELECT OwnerID, SessionID, OwnerType, OwnerItemID, DTSStart, LastChanged FROM Owners WHERE (OwnerID = SCOPE_IDENTITY()) SELECT OwnerID, SessionID, OwnerType, OwnerItemID, DTSStart, LastChanged FROM dbo.Owners UPDATE [dbo].[Owners] SET [SessionID] = @SessionID, [OwnerType] = @OwnerType, [OwnerItemID] = @OwnerItemID, [DTSStart] = @DTSStart WHERE (([OwnerID] = @Original_OwnerID) AND ([LastChanged] = @Original_LastChanged)); SELECT OwnerID, SessionID, OwnerType, OwnerItemID, DTSStart, LastChanged FROM Owners WHERE (OwnerID = @OwnerID) DELETE FROM [dbo].[PartAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([FromType] = @Original_FromType) AND ([ItemID] = @Original_ItemID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[PartAudits] ([ContentID], [FromType], [ItemID], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @FromType, @ItemID, @DTS, @UserID, @DeleteStatus); SELECT AuditID, ContentID, FromType, ItemID, DTS, UserID, DeleteStatus FROM PartAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ContentID, FromType, ItemID, DTS, UserID, DeleteStatus FROM dbo.PartAudits UPDATE [dbo].[PartAudits] SET [ContentID] = @ContentID, [FromType] = @FromType, [ItemID] = @ItemID, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([ContentID] = @Original_ContentID) AND ([FromType] = @Original_FromType) AND ([ItemID] = @Original_ItemID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, ContentID, FromType, ItemID, DTS, UserID, DeleteStatus FROM PartAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[Pdfs] WHERE (([DocID] = @Original_DocID) AND ([DebugStatus] = @Original_DebugStatus) AND ([TopRow] = @Original_TopRow) AND ([PageLength] = @Original_PageLength) AND ([LeftMargin] = @Original_LeftMargin) AND ([PageWidth] = @Original_PageWidth) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Pdfs] ([DocID], [DebugStatus], [TopRow], [PageLength], [LeftMargin], [PageWidth], [PageCount], [DocPdf], [DTS], [UserID]) VALUES (@DocID, @DebugStatus, @TopRow, @PageLength, @LeftMargin, @PageWidth, @PageCount, @DocPdf, @DTS, @UserID); SELECT DocID, DebugStatus, TopRow, PageLength, LeftMargin, PageWidth, PageCount, DocPdf, DTS, UserID, LastChanged FROM Pdfs WHERE (DebugStatus = @DebugStatus) AND (DocID = @DocID) AND (LeftMargin = @LeftMargin) AND (PageLength = @PageLength) AND (PageWidth = @PageWidth) AND (TopRow = @TopRow) SELECT DocID, DebugStatus, TopRow, PageLength, LeftMargin, PageWidth, PageCount, DocPdf, DTS, UserID, LastChanged FROM dbo.Pdfs UPDATE [dbo].[Pdfs] SET [DocID] = @DocID, [DebugStatus] = @DebugStatus, [TopRow] = @TopRow, [PageLength] = @PageLength, [LeftMargin] = @LeftMargin, [PageWidth] = @PageWidth, [PageCount] = @PageCount, [DocPdf] = @DocPdf, [DTS] = @DTS, [UserID] = @UserID WHERE (([DocID] = @Original_DocID) AND ([DebugStatus] = @Original_DebugStatus) AND ([TopRow] = @Original_TopRow) AND ([PageLength] = @Original_PageLength) AND ([LeftMargin] = @Original_LeftMargin) AND ([PageWidth] = @Original_PageWidth) AND ([LastChanged] = @Original_LastChanged)); SELECT DocID, DebugStatus, TopRow, PageLength, LeftMargin, PageWidth, PageCount, DocPdf, DTS, UserID, LastChanged FROM Pdfs WHERE (DebugStatus = @DebugStatus) AND (DocID = @DocID) AND (LeftMargin = @LeftMargin) AND (PageLength = @PageLength) AND (PageWidth = @PageWidth) AND (TopRow = @TopRow) DELETE FROM [dbo].[Permissions] WHERE (([PID] = @Original_PID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Permissions] ([RID], [PermLevel], [VersionType], [PermValue], [PermAD], [StartDate], [EndDate], [Config], [DTS], [UsrID]) VALUES (@RID, @PermLevel, @VersionType, @PermValue, @PermAD, @StartDate, @EndDate, @Config, @DTS, @UsrID); SELECT PID, RID, PermLevel, VersionType, PermValue, PermAD, StartDate, EndDate, Config, DTS, UsrID, LastChanged FROM Permissions WHERE (PID = SCOPE_IDENTITY()) SELECT PID, RID, PermLevel, VersionType, PermValue, PermAD, StartDate, EndDate, Config, DTS, UsrID, LastChanged FROM dbo.Permissions UPDATE [dbo].[Permissions] SET [RID] = @RID, [PermLevel] = @PermLevel, [VersionType] = @VersionType, [PermValue] = @PermValue, [PermAD] = @PermAD, [StartDate] = @StartDate, [EndDate] = @EndDate, [Config] = @Config, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([PID] = @Original_PID) AND ([LastChanged] = @Original_LastChanged)); SELECT PID, RID, PermLevel, VersionType, PermValue, PermAD, StartDate, EndDate, Config, DTS, UsrID, LastChanged FROM Permissions WHERE (PID = @PID) DELETE FROM [dbo].[Revisions] WHERE (([RevisionID] = @Original_RevisionID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Revisions] ([ItemID], [TypeID], [RevisionNumber], [RevisionDate], [Notes], [Config], [DTS], [UserID]) VALUES (@ItemID, @TypeID, @RevisionNumber, @RevisionDate, @Notes, @Config, @DTS, @UserID); SELECT RevisionID, ItemID, TypeID, RevisionNumber, RevisionDate, Notes, Config, DTS, UserID, LastChanged FROM Revisions WHERE (RevisionID = SCOPE_IDENTITY()) SELECT RevisionID, ItemID, TypeID, RevisionNumber, RevisionDate, Notes, Config, DTS, UserID, LastChanged FROM dbo.Revisions UPDATE [dbo].[Revisions] SET [ItemID] = @ItemID, [TypeID] = @TypeID, [RevisionNumber] = @RevisionNumber, [RevisionDate] = @RevisionDate, [Notes] = @Notes, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([RevisionID] = @Original_RevisionID) AND ([LastChanged] = @Original_LastChanged)); SELECT RevisionID, ItemID, TypeID, RevisionNumber, RevisionDate, Notes, Config, DTS, UserID, LastChanged FROM Revisions WHERE (RevisionID = @RevisionID) DELETE FROM [dbo].[RODbs] WHERE (([RODbID] = @Original_RODbID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[RODbs] ([ROName], [FolderPath], [DBConnectionString], [Config], [DTS], [UserID]) VALUES (@ROName, @FolderPath, @DBConnectionString, @Config, @DTS, @UserID); SELECT RODbID, ROName, FolderPath, DBConnectionString, Config, DTS, UserID, LastChanged FROM RODbs WHERE (RODbID = SCOPE_IDENTITY()) SELECT RODbID, ROName, FolderPath, DBConnectionString, Config, DTS, UserID, LastChanged FROM dbo.RODbs UPDATE [dbo].[RODbs] SET [ROName] = @ROName, [FolderPath] = @FolderPath, [DBConnectionString] = @DBConnectionString, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([RODbID] = @Original_RODbID) AND ([LastChanged] = @Original_LastChanged)); SELECT RODbID, ROName, FolderPath, DBConnectionString, Config, DTS, UserID, LastChanged FROM RODbs WHERE (RODbID = @RODbID) DELETE FROM [dbo].[RofstChild] WHERE (([RofstChildID] = @Original_RofstChildID) AND ([RofstID] = @Original_RofstID) AND ([dbiID] = @Original_dbiID) AND ([ID] = @Original_ID) AND ([ParentID] = @Original_ParentID) AND ([type] = @Original_type) AND ([roid] = @Original_roid)) INSERT INTO [dbo].[RofstChild] ([RofstID], [dbiID], [ID], [ParentID], [type], [title], [roid], [appid], [value]) VALUES (@RofstID, @dbiID, @ID, @ParentID, @type, @title, @roid, @appid, @value); SELECT RofstChildID, RofstID, dbiID, ID, ParentID, type, title, roid, appid, value FROM RofstChild WHERE (RofstChildID = SCOPE_IDENTITY()) SELECT RofstChildID, RofstID, dbiID, ID, ParentID, type, title, roid, appid, value FROM dbo.RofstChild UPDATE [dbo].[RofstChild] SET [RofstID] = @RofstID, [dbiID] = @dbiID, [ID] = @ID, [ParentID] = @ParentID, [type] = @type, [title] = @title, [roid] = @roid, [appid] = @appid, [value] = @value WHERE (([RofstChildID] = @Original_RofstChildID) AND ([RofstID] = @Original_RofstID) AND ([dbiID] = @Original_dbiID) AND ([ID] = @Original_ID) AND ([ParentID] = @Original_ParentID) AND ([type] = @Original_type) AND ([roid] = @Original_roid)); SELECT RofstChildID, RofstID, dbiID, ID, ParentID, type, title, roid, appid, value FROM RofstChild WHERE (RofstChildID = @RofstChildID) DELETE FROM [dbo].[RofstDatabase] WHERE (([RofstID] = @Original_RofstID) AND ([dbiID] = @Original_dbiID) AND ([dbiType] = @Original_dbiType) AND ([dbiAW] = @Original_dbiAW) AND ([ID] = @Original_ID) AND ([ParentID] = @Original_ParentID)) INSERT INTO [dbo].[RofstDatabase] ([RofstID], [dbiID], [dbiType], [dbiAW], [dbiTitle], [dbiAP], [ID], [ParentID]) VALUES (@RofstID, @dbiID, @dbiType, @dbiAW, @dbiTitle, @dbiAP, @ID, @ParentID); SELECT RofstID, dbiID, dbiType, dbiAW, dbiTitle, dbiAP, ID, ParentID FROM RofstDatabase WHERE (RofstID = @RofstID) AND (dbiID = @dbiID) SELECT RofstID, dbiID, dbiType, dbiAW, dbiTitle, dbiAP, ID, ParentID FROM dbo.RofstDatabase UPDATE [dbo].[RofstDatabase] SET [RofstID] = @RofstID, [dbiID] = @dbiID, [dbiType] = @dbiType, [dbiAW] = @dbiAW, [dbiTitle] = @dbiTitle, [dbiAP] = @dbiAP, [ID] = @ID, [ParentID] = @ParentID WHERE (([RofstID] = @Original_RofstID) AND ([dbiID] = @Original_dbiID) AND ([dbiType] = @Original_dbiType) AND ([dbiAW] = @Original_dbiAW) AND ([ID] = @Original_ID) AND ([ParentID] = @Original_ParentID)); SELECT RofstID, dbiID, dbiType, dbiAW, dbiTitle, dbiAP, ID, ParentID FROM RofstDatabase WHERE (RofstID = @RofstID) AND (dbiID = @dbiID) DELETE FROM [dbo].[RofstDefaultValue] WHERE (([RofstID] = @Original_RofstID) AND ([roid] = @Original_roid)) INSERT INTO [dbo].[RofstDefaultValue] ([RofstID], [roid], [value], [AccPageID]) VALUES (@RofstID, @roid, @value, @AccPageID); SELECT RofstID, roid, value, AccPageID FROM RofstDefaultValue WHERE (RofstID = @RofstID) AND (roid = @roid) SELECT RofstID, roid, value, AccPageID FROM dbo.RofstDefaultValue UPDATE [dbo].[RofstDefaultValue] SET [RofstID] = @RofstID, [roid] = @roid, [value] = @value, [AccPageID] = @AccPageID WHERE (([RofstID] = @Original_RofstID) AND ([roid] = @Original_roid)); SELECT RofstID, roid, value, AccPageID FROM RofstDefaultValue WHERE (RofstID = @RofstID) AND (roid = @roid) DELETE FROM [dbo].[RofstExtension] WHERE (([Offset] = @Original_Offset) AND ([RoidExt] = @Original_RoidExt) AND ([AccPageExt] = @Original_AccPageExt)) INSERT INTO [dbo].[RofstExtension] ([Offset], [RoidExt], [AccPageExt]) VALUES (@Offset, @RoidExt, @AccPageExt); SELECT Offset, RoidExt, AccPageExt FROM RofstExtension WHERE (Offset = @Offset) SELECT Offset, RoidExt, AccPageExt FROM dbo.RofstExtension UPDATE [dbo].[RofstExtension] SET [Offset] = @Offset, [RoidExt] = @RoidExt, [AccPageExt] = @AccPageExt WHERE (([Offset] = @Original_Offset) AND ([RoidExt] = @Original_RoidExt) AND ([AccPageExt] = @Original_AccPageExt)); SELECT Offset, RoidExt, AccPageExt FROM RofstExtension WHERE (Offset = @Offset) DELETE FROM [dbo].[RofstHeader] WHERE (([RofstID] = @Original_RofstID) AND ([hSize] = @Original_hSize) AND ([hMonth] = @Original_hMonth) AND ([hDay] = @Original_hDay) AND ([hcYear] = @Original_hcYear) AND ([hcMonth] = @Original_hcMonth) AND ([hcDay] = @Original_hcDay) AND ([hcHour] = @Original_hcHour) AND ([hcMin] = @Original_hcMin) AND ([hcSec] = @Original_hcSec) AND ([hcHund] = @Original_hcHund) AND ([CreateUserID] = @Original_CreateUserID) AND ([CreateDate] = @Original_CreateDate) AND ((@IsNull_LoadedDate = 1 AND [LoadedDate] IS NULL) OR ([LoadedDate] = @Original_LoadedDate))) INSERT INTO [dbo].[RofstHeader] ([RofstID], [hSize], [hMonth], [hDay], [hcYear], [hcMonth], [hcDay], [hcHour], [hcMin], [hcSec], [hcHund], [CreateUserID], [CreateDate], [LoadedDate]) VALUES (@RofstID, @hSize, @hMonth, @hDay, @hcYear, @hcMonth, @hcDay, @hcHour, @hcMin, @hcSec, @hcHund, @CreateUserID, @CreateDate, @LoadedDate); SELECT RofstID, hSize, hMonth, hDay, hcYear, hcMonth, hcDay, hcHour, hcMin, hcSec, hcHund, CreateUserID, CreateDate, LoadedDate FROM RofstHeader WHERE (RofstID = @RofstID) SELECT RofstID, hSize, hMonth, hDay, hcYear, hcMonth, hcDay, hcHour, hcMin, hcSec, hcHund, CreateUserID, CreateDate, LoadedDate FROM dbo.RofstHeader UPDATE [dbo].[RofstHeader] SET [RofstID] = @RofstID, [hSize] = @hSize, [hMonth] = @hMonth, [hDay] = @hDay, [hcYear] = @hcYear, [hcMonth] = @hcMonth, [hcDay] = @hcDay, [hcHour] = @hcHour, [hcMin] = @hcMin, [hcSec] = @hcSec, [hcHund] = @hcHund, [CreateUserID] = @CreateUserID, [CreateDate] = @CreateDate, [LoadedDate] = @LoadedDate WHERE (([RofstID] = @Original_RofstID) AND ([hSize] = @Original_hSize) AND ([hMonth] = @Original_hMonth) AND ([hDay] = @Original_hDay) AND ([hcYear] = @Original_hcYear) AND ([hcMonth] = @Original_hcMonth) AND ([hcDay] = @Original_hcDay) AND ([hcHour] = @Original_hcHour) AND ([hcMin] = @Original_hcMin) AND ([hcSec] = @Original_hcSec) AND ([hcHund] = @Original_hcHund) AND ([CreateUserID] = @Original_CreateUserID) AND ([CreateDate] = @Original_CreateDate) AND ((@IsNull_LoadedDate = 1 AND [LoadedDate] IS NULL) OR ([LoadedDate] = @Original_LoadedDate))); SELECT RofstID, hSize, hMonth, hDay, hcYear, hcMonth, hcDay, hcHour, hcMin, hcSec, hcHund, CreateUserID, CreateDate, LoadedDate FROM RofstHeader WHERE (RofstID = @RofstID) DELETE FROM [dbo].[ROFsts] WHERE (([ROFstID] = @Original_ROFstID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[ROFsts] ([RODbID], [ROLookup], [Config], [DTS], [UserID]) VALUES (@RODbID, @ROLookup, @Config, @DTS, @UserID); SELECT ROFstID, RODbID, ROLookup, Config, DTS, UserID, LastChanged FROM ROFsts WHERE (ROFstID = SCOPE_IDENTITY()) SELECT ROFstID, RODbID, ROLookup, Config, DTS, UserID, LastChanged FROM dbo.ROFsts UPDATE [dbo].[ROFsts] SET [RODbID] = @RODbID, [ROLookup] = @ROLookup, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([ROFstID] = @Original_ROFstID) AND ([LastChanged] = @Original_LastChanged)); SELECT ROFstID, RODbID, ROLookup, Config, DTS, UserID, LastChanged FROM ROFsts WHERE (ROFstID = @ROFstID) DELETE FROM [dbo].[ROImages] WHERE (([ImageID] = @Original_ImageID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[ROImages] ([RODbID], [FileName], [Content], [Config], [DTS], [UserID]) VALUES (@RODbID, @FileName, @Content, @Config, @DTS, @UserID); SELECT ImageID, RODbID, FileName, [Content], Config, DTS, UserID, LastChanged FROM ROImages WHERE (ImageID = SCOPE_IDENTITY()) SELECT ImageID, RODbID, FileName, Content, Config, DTS, UserID, LastChanged FROM dbo.ROImages UPDATE [dbo].[ROImages] SET [RODbID] = @RODbID, [FileName] = @FileName, [Content] = @Content, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID WHERE (([ImageID] = @Original_ImageID) AND ([LastChanged] = @Original_LastChanged)); SELECT ImageID, RODbID, FileName, [Content], Config, DTS, UserID, LastChanged FROM ROImages WHERE (ImageID = @ImageID) DELETE FROM [dbo].[Roles] WHERE (([RID] = @Original_RID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Roles] ([Name], [Title], [DTS], [UsrID]) VALUES (@Name, @Title, @DTS, @UsrID); SELECT RID, Name, Title, DTS, UsrID, LastChanged FROM Roles WHERE (RID = SCOPE_IDENTITY()) SELECT RID, Name, Title, DTS, UsrID, LastChanged FROM dbo.Roles UPDATE [dbo].[Roles] SET [Name] = @Name, [Title] = @Title, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([RID] = @Original_RID) AND ([LastChanged] = @Original_LastChanged)); SELECT RID, Name, Title, DTS, UsrID, LastChanged FROM Roles WHERE (RID = @RID) DELETE FROM [dbo].[ROUsageAudits] WHERE (([AuditID] = @Original_AuditID) AND ([ROUsageID] = @Original_ROUsageID) AND ([ContentID] = @Original_ContentID) AND ([ROID] = @Original_ROID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([RODbID] = @Original_RODbID) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[ROUsageAudits] ([ROUsageID], [ContentID], [ROID], [Config], [DTS], [UserID], [RODbID], [DeleteStatus]) VALUES (@ROUsageID, @ContentID, @ROID, @Config, @DTS, @UserID, @RODbID, @DeleteStatus); SELECT AuditID, ROUsageID, ContentID, ROID, Config, DTS, UserID, RODbID, DeleteStatus FROM ROUsageAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, ROUsageID, ContentID, ROID, Config, DTS, UserID, RODbID, DeleteStatus FROM dbo.ROUsageAudits UPDATE [dbo].[ROUsageAudits] SET [ROUsageID] = @ROUsageID, [ContentID] = @ContentID, [ROID] = @ROID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [RODbID] = @RODbID, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([ROUsageID] = @Original_ROUsageID) AND ([ContentID] = @Original_ContentID) AND ([ROID] = @Original_ROID) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([RODbID] = @Original_RODbID) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, ROUsageID, ContentID, ROID, Config, DTS, UserID, RODbID, DeleteStatus FROM ROUsageAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[Scopes] WHERE (([ScopeID] = @Original_ScopeID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Scopes] ([Name], [Title], [DTS], [UserID]) VALUES (@Name, @Title, @DTS, @UserID); SELECT ScopeID, Name, Title, DTS, UserID, LastChanged FROM Scopes WHERE (ScopeID = SCOPE_IDENTITY()) SELECT ScopeID, Name, Title, DTS, UserID, LastChanged FROM dbo.Scopes UPDATE [dbo].[Scopes] SET [Name] = @Name, [Title] = @Title, [DTS] = @DTS, [UserID] = @UserID WHERE (([ScopeID] = @Original_ScopeID) AND ([LastChanged] = @Original_LastChanged)); SELECT ScopeID, Name, Title, DTS, UserID, LastChanged FROM Scopes WHERE (ScopeID = @ScopeID) DELETE FROM [dbo].[Sessions] WHERE (([SessionID] = @Original_SessionID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Sessions] ([UserID], [DTSDtart], [DTSEnd], [DTSActivity], [MachineName], [ProcessID]) VALUES (@UserID, @DTSDtart, @DTSEnd, @DTSActivity, @MachineName, @ProcessID); SELECT SessionID, UserID, DTSDtart, DTSEnd, DTSActivity, LastChanged, MachineName, ProcessID FROM Sessions WHERE (SessionID = SCOPE_IDENTITY()) SELECT SessionID, UserID, DTSDtart, DTSEnd, DTSActivity, LastChanged, MachineName, ProcessID FROM dbo.Sessions UPDATE [dbo].[Sessions] SET [UserID] = @UserID, [DTSDtart] = @DTSDtart, [DTSEnd] = @DTSEnd, [DTSActivity] = @DTSActivity, [MachineName] = @MachineName, [ProcessID] = @ProcessID WHERE (([SessionID] = @Original_SessionID) AND ([LastChanged] = @Original_LastChanged)); SELECT SessionID, UserID, DTSDtart, DTSEnd, DTSActivity, LastChanged, MachineName, ProcessID FROM Sessions WHERE (SessionID = @SessionID) DELETE FROM [dbo].[Stages] WHERE (([StageID] = @Original_StageID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Stages] ([Name], [Description], [IsApproved], [DTS], [UserID]) VALUES (@Name, @Description, @IsApproved, @DTS, @UserID); SELECT StageID, Name, Description, IsApproved, DTS, UserID, LastChanged FROM Stages WHERE (StageID = SCOPE_IDENTITY()) SELECT StageID, Name, Description, IsApproved, DTS, UserID, LastChanged FROM dbo.Stages UPDATE [dbo].[Stages] SET [Name] = @Name, [Description] = @Description, [IsApproved] = @IsApproved, [DTS] = @DTS, [UserID] = @UserID WHERE (([StageID] = @Original_StageID) AND ([LastChanged] = @Original_LastChanged)); SELECT StageID, Name, Description, IsApproved, DTS, UserID, LastChanged FROM Stages WHERE (StageID = @StageID) DELETE FROM [dbo].[tblAnnotations] WHERE (([AnnotationID] = @Original_AnnotationID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblAnnotations] ([ItemID], [TypeID], [RtfText], [SearchText], [Config], [DTS], [UserID], [DeleteStatus], [ActionDTS]) VALUES (@ItemID, @TypeID, @RtfText, @SearchText, @Config, @DTS, @UserID, @DeleteStatus, @ActionDTS); SELECT AnnotationID, ItemID, TypeID, RtfText, SearchText, Config, DTS, UserID, LastChanged, DeleteStatus, ActionDTS FROM tblAnnotations WHERE (AnnotationID = SCOPE_IDENTITY()) SELECT AnnotationID, ItemID, TypeID, RtfText, SearchText, Config, DTS, UserID, LastChanged, DeleteStatus, ActionDTS FROM dbo.tblAnnotations UPDATE [dbo].[tblAnnotations] SET [ItemID] = @ItemID, [TypeID] = @TypeID, [RtfText] = @RtfText, [SearchText] = @SearchText, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus, [ActionDTS] = @ActionDTS WHERE (([AnnotationID] = @Original_AnnotationID) AND ([LastChanged] = @Original_LastChanged)); SELECT AnnotationID, ItemID, TypeID, RtfText, SearchText, Config, DTS, UserID, LastChanged, DeleteStatus, ActionDTS FROM tblAnnotations WHERE (AnnotationID = @AnnotationID) DELETE FROM [dbo].[tblContents] WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblContents] ([Number], [Text], [Type], [FormatID], [Config], [DTS], [UserID], [DeleteStatus], [ActionDTS]) VALUES (@Number, @Text, @Type, @FormatID, @Config, @DTS, @UserID, @DeleteStatus, @ActionDTS); SELECT ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, LastChanged, DeleteStatus, ActionDTS FROM tblContents WHERE (ContentID = SCOPE_IDENTITY()) SELECT ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, LastChanged, DeleteStatus, ActionDTS FROM dbo.tblContents UPDATE [dbo].[tblContents] SET [Number] = @Number, [Text] = @Text, [Type] = @Type, [FormatID] = @FormatID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus, [ActionDTS] = @ActionDTS WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)); SELECT ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, LastChanged, DeleteStatus, ActionDTS FROM tblContents WHERE (ContentID = @ContentID) DELETE FROM [dbo].[tblDocuments] WHERE (([DocID] = @Original_DocID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblDocuments] ([LibTitle], [DocContent], [DocAscii], [Config], [DTS], [UserID], [FileExtension], [DeleteStatus]) VALUES (@LibTitle, @DocContent, @DocAscii, @Config, @DTS, @UserID, @FileExtension, @DeleteStatus); SELECT DocID, LibTitle, DocContent, DocAscii, Config, DTS, UserID, LastChanged, FileExtension, DeleteStatus FROM tblDocuments WHERE (DocID = SCOPE_IDENTITY()) SELECT DocID, LibTitle, DocContent, DocAscii, Config, DTS, UserID, LastChanged, FileExtension, DeleteStatus FROM dbo.tblDocuments UPDATE [dbo].[tblDocuments] SET [LibTitle] = @LibTitle, [DocContent] = @DocContent, [DocAscii] = @DocAscii, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [FileExtension] = @FileExtension, [DeleteStatus] = @DeleteStatus WHERE (([DocID] = @Original_DocID) AND ([LastChanged] = @Original_LastChanged)); SELECT DocID, LibTitle, DocContent, DocAscii, Config, DTS, UserID, LastChanged, FileExtension, DeleteStatus FROM tblDocuments WHERE (DocID = @DocID) DELETE FROM [dbo].[tblEntries] WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblEntries] ([ContentID], [DocID], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @DocID, @DTS, @UserID, @DeleteStatus); SELECT ContentID, DocID, DTS, UserID, LastChanged, DeleteStatus FROM tblEntries WHERE (ContentID = @ContentID) SELECT ContentID, DocID, DTS, UserID, LastChanged, DeleteStatus FROM dbo.tblEntries UPDATE [dbo].[tblEntries] SET [ContentID] = @ContentID, [DocID] = @DocID, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)); SELECT ContentID, DocID, DTS, UserID, LastChanged, DeleteStatus FROM tblEntries WHERE (ContentID = @ContentID) DELETE FROM [dbo].[tblGrids] WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblGrids] ([ContentID], [Data], [Config], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @Data, @Config, @DTS, @UserID, @DeleteStatus); SELECT ContentID, Data, Config, DTS, UserID, LastChanged, DeleteStatus FROM tblGrids WHERE (ContentID = @ContentID) SELECT ContentID, Data, Config, DTS, UserID, LastChanged, DeleteStatus FROM dbo.tblGrids UPDATE [dbo].[tblGrids] SET [ContentID] = @ContentID, [Data] = @Data, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)); SELECT ContentID, Data, Config, DTS, UserID, LastChanged, DeleteStatus FROM tblGrids WHERE (ContentID = @ContentID) DELETE FROM [dbo].[tblImages] WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblImages] ([ContentID], [ImageType], [FileName], [Data], [Config], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @ImageType, @FileName, @Data, @Config, @DTS, @UserID, @DeleteStatus); SELECT ContentID, ImageType, FileName, Data, Config, DTS, UserID, LastChanged, DeleteStatus FROM tblImages WHERE (ContentID = @ContentID) SELECT ContentID, ImageType, FileName, Data, Config, DTS, UserID, LastChanged, DeleteStatus FROM dbo.tblImages UPDATE [dbo].[tblImages] SET [ContentID] = @ContentID, [ImageType] = @ImageType, [FileName] = @FileName, [Data] = @Data, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)); SELECT ContentID, ImageType, FileName, Data, Config, DTS, UserID, LastChanged, DeleteStatus FROM tblImages WHERE (ContentID = @ContentID) DELETE FROM [dbo].[tblItems] WHERE (([ItemID] = @Original_ItemID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblItems] ([PreviousID], [ContentID], [DTS], [UserID], [DeleteStatus]) VALUES (@PreviousID, @ContentID, @DTS, @UserID, @DeleteStatus); SELECT ItemID, PreviousID, ContentID, DTS, UserID, LastChanged, DeleteStatus FROM tblItems WHERE (ItemID = SCOPE_IDENTITY()) SELECT ItemID, PreviousID, ContentID, DTS, UserID, LastChanged, DeleteStatus FROM dbo.tblItems UPDATE [dbo].[tblItems] SET [PreviousID] = @PreviousID, [ContentID] = @ContentID, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([ItemID] = @Original_ItemID) AND ([LastChanged] = @Original_LastChanged)); SELECT ItemID, PreviousID, ContentID, DTS, UserID, LastChanged, DeleteStatus FROM tblItems WHERE (ItemID = @ItemID) DELETE FROM [dbo].[tblParts] WHERE (([ContentID] = @Original_ContentID) AND ([FromType] = @Original_FromType) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblParts] ([ContentID], [FromType], [ItemID], [DTS], [UserID], [DeleteStatus]) VALUES (@ContentID, @FromType, @ItemID, @DTS, @UserID, @DeleteStatus); SELECT ContentID, FromType, ItemID, DTS, UserID, LastChanged, DeleteStatus FROM tblParts WHERE (ContentID = @ContentID) AND (FromType = @FromType) SELECT ContentID, FromType, ItemID, DTS, UserID, LastChanged, DeleteStatus FROM dbo.tblParts UPDATE [dbo].[tblParts] SET [ContentID] = @ContentID, [FromType] = @FromType, [ItemID] = @ItemID, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([ContentID] = @Original_ContentID) AND ([FromType] = @Original_FromType) AND ([LastChanged] = @Original_LastChanged)); SELECT ContentID, FromType, ItemID, DTS, UserID, LastChanged, DeleteStatus FROM tblParts WHERE (ContentID = @ContentID) AND (FromType = @FromType) DELETE FROM [dbo].[tblROUsages] WHERE (([ROUsageID] = @Original_ROUsageID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblROUsages] ([ContentID], [ROID], [Config], [DTS], [UserID], [RODbID], [DeleteStatus]) VALUES (@ContentID, @ROID, @Config, @DTS, @UserID, @RODbID, @DeleteStatus); SELECT ROUsageID, ContentID, ROID, Config, DTS, UserID, LastChanged, RODbID, DeleteStatus FROM tblROUsages WHERE (ROUsageID = SCOPE_IDENTITY()) SELECT ROUsageID, ContentID, ROID, Config, DTS, UserID, LastChanged, RODbID, DeleteStatus FROM dbo.tblROUsages UPDATE [dbo].[tblROUsages] SET [ContentID] = @ContentID, [ROID] = @ROID, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [RODbID] = @RODbID, [DeleteStatus] = @DeleteStatus WHERE (([ROUsageID] = @Original_ROUsageID) AND ([LastChanged] = @Original_LastChanged)); SELECT ROUsageID, ContentID, ROID, Config, DTS, UserID, LastChanged, RODbID, DeleteStatus FROM tblROUsages WHERE (ROUsageID = @ROUsageID) DELETE FROM [dbo].[tblTransitions] WHERE (([TransitionID] = @Original_TransitionID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[tblTransitions] ([FromID], [ToID], [RangeID], [IsRange], [TranType], [Config], [DTS], [UserID], [DeleteStatus]) VALUES (@FromID, @ToID, @RangeID, @IsRange, @TranType, @Config, @DTS, @UserID, @DeleteStatus); SELECT TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID, LastChanged, DeleteStatus FROM tblTransitions WHERE (TransitionID = SCOPE_IDENTITY()) SELECT TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID, LastChanged, DeleteStatus FROM dbo.tblTransitions UPDATE [dbo].[tblTransitions] SET [FromID] = @FromID, [ToID] = @ToID, [RangeID] = @RangeID, [IsRange] = @IsRange, [TranType] = @TranType, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([TransitionID] = @Original_TransitionID) AND ([LastChanged] = @Original_LastChanged)); SELECT TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID, LastChanged, DeleteStatus FROM tblTransitions WHERE (TransitionID = @TransitionID) DELETE FROM [dbo].[TransitionAudits] WHERE (([AuditID] = @Original_AuditID) AND ([TransitionID] = @Original_TransitionID) AND ([FromID] = @Original_FromID) AND ([ToID] = @Original_ToID) AND ([RangeID] = @Original_RangeID) AND ([IsRange] = @Original_IsRange) AND ([TranType] = @Original_TranType) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)) INSERT INTO [dbo].[TransitionAudits] ([TransitionID], [FromID], [ToID], [RangeID], [IsRange], [TranType], [Config], [DTS], [UserID], [DeleteStatus]) VALUES (@TransitionID, @FromID, @ToID, @RangeID, @IsRange, @TranType, @Config, @DTS, @UserID, @DeleteStatus); SELECT AuditID, TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID, DeleteStatus FROM TransitionAudits WHERE (AuditID = SCOPE_IDENTITY()) SELECT AuditID, TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID, DeleteStatus FROM dbo.TransitionAudits UPDATE [dbo].[TransitionAudits] SET [TransitionID] = @TransitionID, [FromID] = @FromID, [ToID] = @ToID, [RangeID] = @RangeID, [IsRange] = @IsRange, [TranType] = @TranType, [Config] = @Config, [DTS] = @DTS, [UserID] = @UserID, [DeleteStatus] = @DeleteStatus WHERE (([AuditID] = @Original_AuditID) AND ([TransitionID] = @Original_TransitionID) AND ([FromID] = @Original_FromID) AND ([ToID] = @Original_ToID) AND ([RangeID] = @Original_RangeID) AND ([IsRange] = @Original_IsRange) AND ([TranType] = @Original_TranType) AND ([DTS] = @Original_DTS) AND ([UserID] = @Original_UserID) AND ([DeleteStatus] = @Original_DeleteStatus)); SELECT AuditID, TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID, DeleteStatus FROM TransitionAudits WHERE (AuditID = @AuditID) DELETE FROM [dbo].[Users] WHERE (([UID] = @Original_UID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Users] ([UserID], [FirstName], [MiddleName], [LastName], [Suffix], [CourtesyTitle], [PhoneNumber], [CFGName], [UserLogin], [UserName], [Config], [DTS], [UsrID]) VALUES (@UserID, @FirstName, @MiddleName, @LastName, @Suffix, @CourtesyTitle, @PhoneNumber, @CFGName, @UserLogin, @UserName, @Config, @DTS, @UsrID); SELECT UID, UserID, FirstName, MiddleName, LastName, Suffix, CourtesyTitle, PhoneNumber, CFGName, UserLogin, UserName, Config, DTS, UsrID, LastChanged FROM Users WHERE (UID = SCOPE_IDENTITY()) SELECT UID, UserID, FirstName, MiddleName, LastName, Suffix, CourtesyTitle, PhoneNumber, CFGName, UserLogin, UserName, Config, DTS, UsrID, LastChanged FROM dbo.Users UPDATE [dbo].[Users] SET [UserID] = @UserID, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [Suffix] = @Suffix, [CourtesyTitle] = @CourtesyTitle, [PhoneNumber] = @PhoneNumber, [CFGName] = @CFGName, [UserLogin] = @UserLogin, [UserName] = @UserName, [Config] = @Config, [DTS] = @DTS, [UsrID] = @UsrID WHERE (([UID] = @Original_UID) AND ([LastChanged] = @Original_LastChanged)); SELECT UID, UserID, FirstName, MiddleName, LastName, Suffix, CourtesyTitle, PhoneNumber, CFGName, UserLogin, UserName, Config, DTS, UsrID, LastChanged FROM Users WHERE (UID = @UID) DELETE FROM [dbo].[Versions] WHERE (([VersionID] = @Original_VersionID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[Versions] ([RevisionID], [StageID], [PDF], [SummaryPDF], [DTS], [UserID], [ApprovedXML]) VALUES (@RevisionID, @StageID, @PDF, @SummaryPDF, @DTS, @UserID, @ApprovedXML); SELECT VersionID, RevisionID, StageID, PDF, SummaryPDF, DTS, UserID, LastChanged, ApprovedXML FROM Versions WHERE (VersionID = SCOPE_IDENTITY()) SELECT VersionID, RevisionID, StageID, PDF, SummaryPDF, DTS, UserID, LastChanged, ApprovedXML FROM dbo.Versions UPDATE [dbo].[Versions] SET [RevisionID] = @RevisionID, [StageID] = @StageID, [PDF] = @PDF, [SummaryPDF] = @SummaryPDF, [DTS] = @DTS, [UserID] = @UserID, [ApprovedXML] = @ApprovedXML WHERE (([VersionID] = @Original_VersionID) AND ([LastChanged] = @Original_LastChanged)); SELECT VersionID, RevisionID, StageID, PDF, SummaryPDF, DTS, UserID, LastChanged, ApprovedXML FROM Versions WHERE (VersionID = @VersionID) DELETE FROM [dbo].[ZContents] WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[ZContents] ([ContentID], [OldStepSequence]) VALUES (@ContentID, @OldStepSequence); SELECT ContentID, OldStepSequence, LastChanged FROM ZContents WHERE (ContentID = @ContentID) SELECT ContentID, OldStepSequence, LastChanged FROM dbo.ZContents UPDATE [dbo].[ZContents] SET [ContentID] = @ContentID, [OldStepSequence] = @OldStepSequence WHERE (([ContentID] = @Original_ContentID) AND ([LastChanged] = @Original_LastChanged)); SELECT ContentID, OldStepSequence, LastChanged FROM ZContents WHERE (ContentID = @ContentID) DELETE FROM [dbo].[ZTransitions] WHERE (([TransitionID] = @Original_TransitionID) AND ([LastChanged] = @Original_LastChanged)) INSERT INTO [dbo].[ZTransitions] ([TransitionID], [oldto]) VALUES (@TransitionID, @oldto); SELECT TransitionID, oldto, LastChanged FROM ZTransitions WHERE (TransitionID = @TransitionID) SELECT TransitionID, oldto, LastChanged FROM dbo.ZTransitions UPDATE [dbo].[ZTransitions] SET [TransitionID] = @TransitionID, [oldto] = @oldto WHERE (([TransitionID] = @Original_TransitionID) AND ([LastChanged] = @Original_LastChanged)); SELECT TransitionID, oldto, LastChanged FROM ZTransitions WHERE (TransitionID = @TransitionID) dbo.addFiguresByROFstIDandImageIDs dbo.addItemChild dbo.addItemSiblingAfter dbo.addItemSiblingBefore dbo.ClearCBOverrideForProcedure dbo.DeleteItemAndChildrenTest dbo.existsAnnotation dbo.existsAnnotationType dbo.existsAssignment dbo.existsAssociation dbo.existsCheck dbo.existsConnection dbo.existsContent dbo.existsDetail dbo.existsDocument dbo.existsDocVersion dbo.existsDROUsage dbo.existsEntry dbo.existsFigure dbo.existsFolder dbo.existsFormat dbo.existsGrid dbo.existsGroup dbo.existsImage dbo.existsItem dbo.existsMembership dbo.existsOwner dbo.existsPart dbo.existsPdf dbo.existsPermission dbo.existsRevision dbo.existsRODb dbo.existsROFst dbo.existsROImage dbo.existsRole dbo.existsRoUsage dbo.existsSession dbo.existsStage dbo.existsTransition dbo.existsUser dbo.existsVersion dbo.existsZContent dbo.existsZTransition dbo.getAffectedDRoUsages dbo.getAffectedRoUsages dbo.getAffectedTransitions dbo.getAllFormats dbo.getAnnotation dbo.getAnnotationAudit dbo.getAnnotationAudits dbo.getAnnotationAuditsByAnnotationID dbo.getAnnotationAuditsByItemID dbo.getAnnotationAuditsChronologyByItemID dbo.getAnnotationAuditsChronologyByItemIDandUnitID dbo.getAnnotations dbo.getAnnotationsByItemID dbo.getAnnotationsByTypeID dbo.getAnnotationType dbo.getAnnotationTypeByName dbo.getAnnotationTypes dbo.getAssignment dbo.getAssignments dbo.getAssignmentsByFolderID dbo.getAssignmentsByGID dbo.getAssignmentsByRID dbo.getAssociation dbo.getAssociationByVersionID_ROFstID dbo.getAssociations dbo.getAssociationsByROFstID dbo.getAssociationsByVersionID dbo.getCheck dbo.getChecks dbo.getChecksByRevisionID dbo.getChecksByStageID dbo.getChildFolders dbo.getChildFormats dbo.getConnection dbo.getConnectionByName dbo.getConnections dbo.getContent dbo.getContentAudit dbo.getContentAudits dbo.getContentAuditsByContentID dbo.getContentAuditsByContentIDandDTS dbo.getContentAuditsByDeleteStatus dbo.getContentAuditsChronologyByItemID dbo.getContentAuditsChronologyByItemIDandUnitID dbo.getContentAuditsSummaryByItemID dbo.getContentAuditsSummaryByItemIDandUnitID dbo.getContents dbo.getContentsByFormatID dbo.getCurrentRevisionByItemID dbo.getCurrentRevisionByItemIDandUnitID dbo.getDetail dbo.getDetails dbo.getDetailsByContentID dbo.getDocument dbo.getDocumentAudit dbo.getDocumentAudits dbo.getDocumentAuditsByDocID dbo.getDocumentByLibDoc dbo.getDocuments dbo.getDocVersion dbo.getDocVersions dbo.getDocVersionsByFolderID dbo.getDocVersionsByFormatID dbo.getDocVersionsByItemID dbo.getDROUsage dbo.getDROUsages dbo.getDROUsagesByDocID dbo.getDROUsagesByRODbID dbo.getDRoUsagesByROIDs dbo.getDRoUsagesByROIDsAndVersions dbo.getDROUsagesForProc dbo.getEntries dbo.getEntriesByContentID dbo.getEntriesByDocID dbo.getEntry dbo.getEntryAudit dbo.getEntryAudits dbo.getEntryAuditsByContentID dbo.getExternalTransitions dbo.getExternalTransitionsToChildren dbo.getFigure dbo.getFigureByROFstID_ImageID dbo.getFigures dbo.getFiguresByImageID dbo.getFiguresByROFstID dbo.getFolder dbo.getFolderByParentID_Name dbo.getFolders dbo.getFoldersByDBID dbo.getFoldersByFormatID dbo.getFormat dbo.getFormatByName dbo.getFormatByParentID_Name dbo.getFormatListUsed dbo.getFormatNoUCF dbo.getFormats dbo.getGrid dbo.getGridAudit dbo.getGridAudits dbo.getGridAuditsByContentID dbo.getGridIds dbo.getGrids dbo.getGridsByContentID dbo.getGroup dbo.getGroupByGroupName dbo.getGroups dbo.getImage dbo.getImageAudit dbo.getImageAudits dbo.getImageAuditsByContentID dbo.getImages dbo.getImagesByContentID dbo.getItem dbo.getItemAndChildren dbo.getItemAudit dbo.getItemAudits dbo.getItemAuditsByItemID dbo.getItemNextAndChildren dbo.getItems dbo.getItemsByContentID dbo.getItemsByPartType dbo.getItemsByPartTypeAndContent dbo.getJustFormat dbo.getJustRODb dbo.getJustROFst dbo.getJustROImage dbo.getJustStage dbo.getLibDocsForProc dbo.getLibraryDocuments dbo.getMembership dbo.getMemberships dbo.getMembershipsByGID dbo.getMembershipsByUID dbo.getNextItems dbo.getOwner dbo.getOwnerByItemID dbo.getOwnerBySessionIDandFolderID dbo.getOwnerBySessionIDandVersionID dbo.getOwners dbo.getOwnersBySessionID dbo.getOwnersByVersionID dbo.getParentFolder dbo.getParentFormat dbo.getPart dbo.getPartAudit dbo.getPartAudits dbo.getPartAuditsByContentID dbo.getPartAuditsByDeleteStatus dbo.getPartAuditsByItemID dbo.getParts dbo.getPartsByContentID dbo.getPartsByItemID dbo.getPastedAffectedTransitions dbo.getPdf dbo.getPdfs dbo.getPdfsByDocID dbo.getPermission dbo.getPermissions dbo.getPermissionsByRID dbo.getPreviousItem dbo.getPreviousRevisionByItemID dbo.getRevision dbo.getRevisionByItemIDandRevisionNumber dbo.getRevisionByItemIDandRevisionNumberAndUnitID dbo.getRevisions dbo.getRevisionsByItemID dbo.getRevisionsByItemIDandUnitID dbo.getRODb dbo.getRODbByFolderPath dbo.getRODbs dbo.getROFst dbo.getROFstByRODbID_DTS dbo.getRoFstBySize dbo.getROFsts dbo.getROFstsByRODbID dbo.getROImage dbo.getROImageByRODbID_FileName_DTS dbo.getROImageByROFstID_FileName dbo.getROImages dbo.getROImagesByRODbID dbo.getROImagesByRODbID_FileName dbo.getROImagesByRODbIDNoData dbo.getRole dbo.getRoleByName dbo.getRoles dbo.getRoUsage dbo.getRoUsages dbo.getRoUsagesByContentID dbo.getRoUsagesByRODbID dbo.getRoUsagesByROIDs dbo.getRoUsagesByROIDsAndVersions dbo.getRoUsagesForDocVersion dbo.getRoUsagesForProc dbo.getSession dbo.getSessions dbo.getStage dbo.getStages dbo.getTopFolder dbo.getTransition dbo.getTransitions dbo.getTransitionsByFromID dbo.getTransitionsByRangeID dbo.getTransitionsByToID dbo.getTransitionsFromProc dbo.getTransitionsToDisconnected dbo.getTransitionsToNonEditable dbo.getTransitionsToProc dbo.getUser dbo.getUserByUserID dbo.getUsers dbo.getVersion dbo.getVersions dbo.getVersionsByRevisionID dbo.getVersionsByStageID dbo.getZContent dbo.getZContents dbo.getZContentsByContentID dbo.getZTransition dbo.getZTransitions dbo.getZTransitionsByTransitionID dbo.MoveItem dbo.vesp_CanTransitionBeCreated dbo.vesp_ClearOverrideFormatsByDocVersion dbo.vesp_ClearOverrideFormatsByFolder dbo.vesp_ClearOverrideFormatsByItem dbo.vesp_Convert16to32EnhancedContents dbo.vesp_Get16BitEnhancedContents dbo.vesp_GetAllConsistencyIssues dbo.vesp_GetConsistencyCheckProcedures dbo.vesp_GetDatabaseSessions dbo.vesp_GetDisconnectedItemsCount dbo.vesp_GetFormatVersions dbo.vesp_GetNonEditableItems dbo.vesp_GetNonEnhancedDocVersions dbo.vesp_GetROUsagesByProcedure dbo.vesp_GetSQLCodeRevision dbo.vesp_GetTransitionReportData dbo.vesp_GetTranTypesByFormatID dbo.vesp_GetUnusedFiguresCount dbo.vesp_GetUnusedROAssociationsCount dbo.vesp_GetUnusedRoFstsCount dbo.vesp_ListChildren dbo.vesp_ListContentPath dbo.vesp_ListContentsAfterLastChanged dbo.vesp_ListContentsAfterLastChanged2 dbo.vesp_ListContentsByItemID dbo.vesp_ListItemAndChildren dbo.vesp_ListItemAndChildrenByUnit dbo.vesp_ListItems dbo.vesp_ListItemsAfterLastChanged dbo.vesp_ListItemsAndContent dbo.vesp_ListItemsToRefresh dbo.vesp_ListItemsTranFrom dbo.vesp_ListItemsTranFromAndContent dbo.vesp_ListItemsTranTo dbo.vesp_ListItemsTranToAndContent dbo.vesp_ListTables dbo.vesp_ListTables2 dbo.vesp_ListTables3 dbo.vesp_ListUnlinkedItems dbo.vesp_PurgeDisconnectedData dbo.vesp_PurgeEnhancedDocVersionsAndChildren dbo.vesp_PurgeEnhancedItemsAndChildren dbo.vesp_PurgeProcLinkedItemsAndChildren dbo.vesp_RofstDataGetBaseAccPageKeys dbo.vesp_RofstDataGetChildByAccPageID dbo.vesp_RofstDataGetChildByRoid dbo.vesp_RofstDataGetChildrenByID dbo.vesp_RofstDataGetChildrenByRofstID dbo.vesp_RofstDataGetChildrenByRoid dbo.vesp_RofstDataGetChildrenByType dbo.vesp_RofstDataGetDatabaseByID dbo.vesp_RofstDataGetDatabases dbo.vesp_RofstDataGetExtensions dbo.vesp_RofstDataGetHeaderRofstByID dbo.vesp_RofstDataGetRofstByID dbo.vesp_RofstDataGetValueDifferences dbo.vesp_SearchAnnotationItemAndChildren dbo.vesp_SearchItemAndChildren dbo.vesp_SearchItemAndChildrenNew dbo.vesp_SearchItemAndChildrenNewByWord dbo.vesp_SearchROItemAndChildren dbo.vesp_SearchSepcifiedApplicability dbo.vesp_SearchTransitions dbo.vesp_SessionBegin dbo.vesp_SessionCanCheckOutItem dbo.vesp_UpdateVersionFormatForUCF dbo.vesp_WillTransitionsBeValid SELECT AnnotationID FROM dbo.FindAnnotations(@AnnotationTypeList, @SearchString, @CaseSensitive, @StepTypeList) SELECT ContentID FROM dbo.FindRoUsages(@ROSearchString) SELECT ItemID, ContentID FROM dbo.FindText(@LookFor) SELECT ParentID, ItemID, Ordinal, Path FROM dbo.vefn_AllHighLevelSteps() SELECT ParentID, ItemID, Ordinal, Path, TransCount, ExternalTransitions, ExternalChildTransitions, InternalTransitions FROM dbo.vefn_AllHighLevelStepTransitions() SELECT ItemID, Ordinal FROM dbo.vefn_AllSiblingItems(@ItemID) SELECT TypeID, Name FROM dbo.vefn_AnnotationTypeSplit(@AnnotationTypeList) SELECT ItemID, ContentID FROM dbo.vefn_ChildItems(@ItemID) SELECT ItemID, ContentID, FormatID FROM dbo.vefn_ChildItemsRange(@StartItemID, @EndItemID, @DestFormat) SELECT ItemID, ContentID, [Level] FROM dbo.vefn_ChildItemz(@ItemID) SELECT ItemID, ContentID FROM dbo.vefn_ChildrenItems(@ItemID, @ParentID) SELECT src, AuditID, ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, DeleteStatus, ActionDTS, ItemDTS, LastAuditID, DeletedAuditID FROM dbo.vefn_ChronologyReport(@ProcItemID, @DTS) SELECT VersionID, ItemID, DVPath, UnitPrefix FROM dbo.vefn_DocVersionSplit(@DocVersionList) SELECT ContentID FROM dbo.vefn_DVContent(@DocVersionList) SELECT TransitionID FROM dbo.vefn_FindAffectedTransitions(@ItemID) SELECT ContentID, Type, Text FROM dbo.vefn_FindContentText(@DocVersionList, @SearchString, @IncludeLinks, @IncludeRtfFormatting, @IncludeSpecialCharacters) SELECT FromItemID, ToID FROM dbo.vefn_FindExternalChildTransitions(@ItemID) SELECT FromItemID, TransitionID, FromID, ToID, RangeID, Config FROM dbo.vefn_FindExternalFromTransitions(@ItemID) SELECT FromItemID, TransitionID, FromID, ToID, RangeID, Config FROM dbo.vefn_FindExternalTransitions(@ItemID) SELECT FromItemID, ToID FROM dbo.vefn_FindInternalTransitions(@ItemID) SELECT TransitionID, FromID, TranType, ToID, RangeID, OldTransition FROM dbo.vefn_FindInternalTransitionsForCopy(@ItemID) SELECT ROUsageID, ROUsageAction FROM dbo.vefn_FindROUsageIDs(@ContentAuditID) SELECT uchar FROM dbo.vefn_FindSpecialChars(@text) SELECT uchar FROM dbo.vefn_FindSpecialChars2(@text) SELECT ContentID FROM dbo.vefn_FindSpecificApplicUsage(@DocVersionList, @ApplicSetting) SELECT ContentID FROM dbo.vefn_FindText(@DocVersionList, @SearchString, @CaseSensitive, @IncludeLinks, @IncludeRtfFormatting, @IncludeSpecialCharacters, @StepTypeList) SELECT TransitionID, TransitionAction FROM dbo.vefn_FindTransitionIDs(@ContentAuditID) SELECT SrcItemID, SrcContentID, SrcConfig, ProcName, RecID, EnhItemID, EnhContentID, EnhConfig, EnhProcName, EnhRecID FROM dbo.vefn_Get16to32EnhancedProcItems(@SourceID, @EnhanceID, @EnhType) SELECT ItemID, ContentID FROM dbo.vefn_GetDisconnectedItems() SELECT VersionID, FolderName, ItemID, ProcNum, ProcName, EnhType, EnhItemID FROM dbo.vefn_GetEnhancedDocuments() SELECT VersionID, Type, Name, FolderID FROM dbo.vefn_GetEnhancedDocVersions(@VersionID) SELECT FolderID, Type, Name, VersionID FROM dbo.vefn_GetEnhancedFolders(@FolderID) SELECT Deleted, Inserted, Changed, Same, Unlinked FROM dbo.vefn_GetEnhancedIssueCount(@EnhancedID) SELECT SourceID, sNumber, sText, sType, sProcName, sRecID, EnhanceID, eNumber, eeText, eType, eProcName, eRecID, Status FROM dbo.vefn_GetEnhancedIssues(@EnhancedID) SELECT [Level], FromType, Ordinal, ParentID, ItemID, PreviousID, ContentID, Number, Text, Type, FormatID, EItemID, EType FROM dbo.vefn_GetEnhancedItemsAndChildren(@ProcID, @EnhType) SELECT svid, bvid, dvid FROM dbo.vefn_GetEnhancedLinks() SELECT VersionID, ItemID, ContentID FROM dbo.vefn_GetEnhancedProcedures(@ItemID) SELECT VersionID, ItemID, ContentID, FormatID FROM dbo.vefn_GetFolderMatchingFormatItems(@FolderID, @OldFormatID, @NewFormatID) SELECT FormatID, Name, Description, Path, Value FROM dbo.vefn_GetFormatField(@find) SELECT FormatID, Name, Description, Path, StepType, Value FROM dbo.vefn_GetFormatFieldByStepType(@find) SELECT FormatID, Name, Description, Path, StepType, Indx, Value FROM dbo.vefn_GetFormatFieldByStepType2(@find) SELECT FormatID, Name, Description, Path FROM dbo.vefn_GetFormatFieldNoValue(@find) SELECT FormatID, Name, ParentNode, Node, FieldValue FROM dbo.vefn_GetFormatValues(@FieldName) SELECT FormatID, Name, Description, MacroName FROM dbo.vefn_GetGenMacMacros() SELECT HyphenString, Offset FROM dbo.vefn_GetHyphenString(@text) SELECT ItemID, ContentID, FormatID FROM dbo.vefn_GetItemsMatchingFormatItems(@ItemID, @OldFormatID, @NewFormatID) SELECT AuditID, ContentID, Number, Text, Type, FormatID, Config, DTS, UserID, DeleteStatus, ActionDTS, ActionWhat, ActionWhen, Path, ItemID, TypeName, ordinalpath FROM dbo.vefn_GetMyChronology(@ProcItemID, @ItemID, @IncludeDeletedChildren, @DTS) SELECT ItemID, ContentID, EItemID, EType FROM dbo.vefn_GetNewEnhancedData(@ItemID, @EnhType) SELECT ItemID, ContentID FROM dbo.vefn_GetNonEditableItems() SELECT FormatID, Name, ParentNode, Node FROM dbo.vefn_GetNullFormatValues(@FieldName) SELECT ItemID, ContentID, ProcName, RecID FROM dbo.vefn_GetOldEnhancedData(@ItemID) SELECT ItemID, ContentID, ProcName, RecID FROM dbo.vefn_GetOldEnhancedItems(@VersionID) SELECT ItemID, ContentID, ProcName, RecID FROM dbo.vefn_GetOldEnhancedProcItems(@ItemID) SELECT ItemID, ContentID, ProcName FROM dbo.vefn_GetOldEnhancedProcs(@VersionID) SELECT Token FROM dbo.vefn_GetROTokens(@text) SELECT Token FROM dbo.vefn_GetTokens(@text) SELECT VersionID, ItemID, ContentID, FormatID, ParentFormatID FROM dbo.vefn_GetVersionFormatItems(@DocVersionList) SELECT VersionID, ItemID, ContentID, FormatID FROM dbo.vefn_GetVersionFormatSections(@DocVersionList) SELECT VersionID, ItemID, ContentID FROM dbo.vefn_GetVersionItems(@DocVersionList) SELECT VersionID, ItemID, ContentID, FormatID FROM dbo.vefn_GetVersionMatchingFormatItems(@DocVersionList, @OldFormatID, @NewFormatID) SELECT VersionID, GrandParentName, ParentName, FolderName FROM dbo.vefn_GetVersionNames() SELECT VersionID, ProcID, ItemID, ContentID FROM dbo.vefn_GetVersionProcedureItems(@DocVersionList) SELECT VersionID, ItemID, ContentID FROM dbo.vefn_GetVersionTblItems(@DocVersionList) SELECT ItemID, ContentID FROM dbo.vefn_GetZeroFromType() SELECT ParentID, ItemID, Path, TransCount, ExternalTransitions, InternalTransitions FROM dbo.vefn_HighLevelStepTransitions(@ItemID, @ParentID) SELECT ItemID, Ordinal FROM dbo.vefn_JustSiblingItems(@FirstItemID) SELECT TransitionID, FromID, ToID, RangeID, TranType, Config FROM dbo.vefn_NextStepTransitions(@ItemID, @PreviousID) SELECT ItemID, ContentID FROM dbo.vefn_ParentItems(@ItemID) SELECT ListPosition, ListValue FROM dbo.vefn_ParseStringListToTable(@List, @Delimeter) SELECT ItemID, DVPath, Path, [Level], FromType, Ordinal, ParentID, PreviousID, ContentID, DTS, UserID, pContentID, pDTS, pUserID, IsRNO, OrdinalPath FROM dbo.vefn_ProcedureByProcID(@ProcID) SELECT FormatID, SectionType, Name, SectionFormatName, TopRow, PageLength, FooterLength, LeftMargin, PageWidth FROM dbo.vefn_SectionFormats() SELECT ItemID, DVPath, Path, [Level], FromType, Ordinal, ParentID, PreviousID, ContentID, DTS, UserID, pContentID, pDTS, pUserID, IsRNO, OrdinalPath FROM dbo.vefn_SiblingAndChildrenItems(@DocVersionList, @UnitPrefix) SELECT ItemID, DVPath, Path, [Level], FromType, Ordinal, ParentID, PreviousID, ContentID, DTS, UserID, pContentID, pDTS, pUserID, IsRNO, OrdinalPath FROM dbo.vefn_SiblingAndChildrenItemsByProc(@ProcID) SELECT ILastChanged, ItemID, DVPath, Path, FromType, Ordinal, ParentID, PreviousID, ContentID, DTS, UserID, pContentID, pDTS, pUserID, IsRNO, Text, DocAscii, Number, CType, CFormatID, CConfig, CDTS, CUserID, CLastChanged, PLastChanged FROM dbo.vefn_SiblingAndChildrenItemsNew(@DocVersionList, @UnitPrefix, @SearchString, @SearchStringx, @StepTypeList) SELECT ILastChanged, ItemID, DVPath, Path, FromType, Ordinal, ParentID, PreviousID, ContentID, DTS, UserID, pContentID, pDTS, pUserID, IsRNO, Text, DocAscii, Number, CType, CFormatID, CConfig, CDTS, CUserID, CLastChanged, PLastChanged FROM dbo.vefn_SiblingAndChildrenItemsNewByWord(@DocVersionList, @UnitPrefix, @SearchString, @SearchStringx, @StepTypeList, @includeLinks, @includeRtfFormatting, @includeSpecialCharacters) SELECT ItemID, ContentID FROM dbo.vefn_SiblingChildrenItems(@ItemID) SELECT ItemID, ContentID, Ordinal FROM dbo.vefn_SiblingItems(@ItemID, @ParentID) SELECT ID FROM dbo.vefn_SplitInt(@text, @delimiter) SELECT RODBID, ROID FROM dbo.vefn_SplitROSearch(@text) SELECT ItemID, ContentID FROM dbo.vefn_StepChildItems(@ItemID) SELECT ItemID, IContentID, IDeleteStatus, ProcDTS, Path, OrdinalPath FROM dbo.vefn_tblChildItems(@ProcItemID, @ItemID, @IncludeDeletedChildren) SELECT TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID FROM dbo.vefn_TransitionsToDisconnected(@DocVersionList) SELECT TransitionID, FromID, ToID, RangeID, IsRange, TranType, Config, DTS, UserID FROM dbo.vefn_TransitionsToNonEditable(@DocVersionList) dbo.addAnnotation dbo.addAnnotationType dbo.addAssignment dbo.addAssociation dbo.addCheck dbo.addConnection dbo.addContent dbo.addDetail dbo.addDocument dbo.addDocVersion dbo.addDROUsage dbo.addEntry dbo.addFigure dbo.addFolder dbo.addFormat dbo.addGrid dbo.addGroup dbo.addImage dbo.addItem dbo.addMembership dbo.addOwner dbo.addPart dbo.addPdf dbo.addPermission dbo.addRevision dbo.addRODb dbo.addROFst dbo.addROImage dbo.addRole dbo.addRoUsage dbo.addSession dbo.addStage dbo.addTransition dbo.addUser dbo.addVersion dbo.addZContent dbo.addZTransition dbo.CopyItemAndChildren dbo.deleteAllDocVersionPdfs dbo.deleteAllPdfs dbo.deleteAnnotation dbo.deleteAnnotationType dbo.deleteAnnotationWithUserID dbo.deleteAssignment dbo.deleteAssociation dbo.deleteCheck dbo.deleteConnection dbo.deleteContent dbo.deleteDetail dbo.deleteDocument dbo.deleteDocVersion dbo.deleteDROUsage dbo.deleteEntry dbo.deleteFigure dbo.deleteFolder dbo.deleteFormat dbo.deleteGrid dbo.deleteGroup dbo.deleteImage dbo.deleteItem dbo.DeleteItemAndChildren dbo.deleteMembership dbo.deleteOwner dbo.deletePart dbo.deletePdf dbo.deletePermission dbo.deleteRevision dbo.deleteRODb dbo.deleteROFst dbo.deleteROImage dbo.deleteRole dbo.deleteRoUsage dbo.deleteSession dbo.deleteStage dbo.deleteTransition dbo.deleteUser dbo.deleteVersion dbo.deleteZContent dbo.deleteZTransition dbo.jcbAuditConfig dbo.PasteDocVersionChild dbo.PasteItemChild dbo.PasteItemReplace dbo.PasteItemSiblingAfter dbo.PasteItemSiblingBefore dbo.purgeData dbo.restoreChangedAnnotation dbo.restoreChangedContent dbo.restoreDeletedAnnotation dbo.restoreDeletedItem dbo.Standardize dbo.updateAnnotation dbo.updateAnnotationType dbo.updateAssignment dbo.updateAssociation dbo.updateCheck dbo.updateConnection dbo.updateContent dbo.updateDetail dbo.updateDocument dbo.updateDocVersion dbo.updateDROUsage dbo.updateEntry dbo.updateFigure dbo.updateFolder dbo.updateFormat dbo.updateGrid dbo.updateGroup dbo.updateImage dbo.updateItem dbo.updateMembership dbo.updateOwner dbo.updatePart dbo.updatePdf dbo.updatePermission dbo.updateRevision dbo.updateRODb dbo.updateROFst dbo.updateROImage dbo.updateRole dbo.updateRoUsage dbo.updateSession dbo.updateStage dbo.updateTransition dbo.updateUser dbo.updateVersion dbo.updateZContent dbo.updateZTransition dbo.vesp_BuildContentsEnhanced dbo.vesp_BuildContentsExport dbo.vesp_BuildDocVersionExport dbo.vesp_CleanUpItems dbo.vesp_CleanUpROAssociations dbo.vesp_ConvertAllEnhanced dbo.vesp_ConvertEnhanced dbo.vesp_ConvertEnhancedDocVersions dbo.vesp_ConvertEnhancedItems dbo.vesp_DeletePDFs dbo.vesp_FixHyphens dbo.vesp_GetFormatFields dbo.vesp_GetFormatFieldsAll dbo.vesp_GetFormatFieldsByStepType dbo.vesp_GetFormatFieldsByStepType2 dbo.vesp_GetFormatFieldsNoValue dbo.vesp_GetFormatGroupFields dbo.vesp_GetFormatGroupFieldsByStepType dbo.vesp_GetFormatGroupFieldsNoValues dbo.vesp_GetGenMacMacros dbo.vesp_PurgeEnhanced dbo.vesp_removeUnUsedFormat dbo.vesp_RemoveUnusedRoFstsAndFigures dbo.vesp_ResetFolderManualOrder dbo.vesp_ResetFolderManualOrderAlphabetical dbo.vesp_ResetSecurity dbo.vesp_RofstChildInsert dbo.vesp_RofstDatabaseInsert dbo.vesp_RofstDataSearch dbo.vesp_RofstHeaderFinalizeLoad dbo.vesp_RofstHeaderInsert dbo.vesp_SessionCheckInItem dbo.vesp_SessionCheckOutItem dbo.vesp_SessionEnd dbo.vesp_SessionPing dbo.vesp_SortProcedures dbo.vesp_TurnChangeManagerOFF dbo.vesp_TurnChangeManagerON dbo.vesp_UtilityCheckIndexes dbo.vlnErrorHandler dbo.ve_GetChildCount dbo.ve_GetFolderPath dbo.ve_GetItemApplicability dbo.ve_GetItemAppliedApplicability dbo.ve_GetItemDerivedApplicability dbo.ve_GetNextTranCount dbo.ve_GetParentItem dbo.ve_GetPartContentID dbo.ve_GetPartFromType dbo.ve_GetParts dbo.ve_GetPartType dbo.ve_GetPath dbo.ve_GetPathFromContentID dbo.ve_GetShortPart dbo.ve_GetShortPath dbo.ve_GetShortPathFromContentID dbo.ve_GetSiblingCount dbo.ve_GetTransitionErrorCount dbo.vefn_AllSections dbo.vefn_CanTransitionBeCreated dbo.vefn_CheckAllXML dbo.vefn_CheckAllXMLByItemID dbo.vefn_CheckXML dbo.vefn_Clean dbo.vefn_CompareROIDs dbo.vefn_CompareTranFormat dbo.vefn_FirstLink dbo.vefn_FixROData dbo.vefn_FixROText dbo.vefn_FixSearchString dbo.vefn_FixSearchStringByWord dbo.vefn_FixTransitionDataForCopy dbo.vefn_FixTransitionText dbo.vefn_FixTransitionTextForCopy dbo.vefn_GetDocumentPageLength dbo.vefn_GetDocVersionInheritedFormat dbo.vefn_GetFormatIDByItemID dbo.vefn_GetInheritedFormat dbo.vefn_GetLastDelim dbo.vefn_GetNewTranType dbo.vefn_GetPreviousRevisionDTSByItemID dbo.vefn_GetStepTypeNameByItemIDandTypeID dbo.vefn_GetTransFormat dbo.vefn_GetUnitPrefix dbo.vefn_GetVersionIDByItemID dbo.vefn_NextCount dbo.vefn_NumOfOccurrences dbo.vefn_RemoveExtraText dbo.vefn_RemoveRange dbo.vefn_RofstDataCleanUnitInfoTags dbo.vefn_RofstDataFormatRoidKey dbo.vefn_RofstDataGetLoadStatus dbo.vefn_RofstDataReplaceApplTagsWithDefaults dbo.vefn_RofstDataReplaceLegacyTagsWithDefaults dbo.vefn_RofstDataReplaceVars dbo.vefn_WillTransitionBeValidFrom dbo.vefn_WillTransitionBeValidTo dbo.vefn_XmlPath