将多行事务数据汇总为一个 [已关闭]

问：

对于为协调事务进程的运行而执行的编程代码的每次迭代，该代码都会将多个审核日志记录写入 SQL Server 数据库表。记录/描述事务流程（有时包括子流程）的状态和结果。为每个事务创建的记录数量因代码（进程）而异，但必须至少生成 2 条记录才能形成有效的事务执行。

构成审计表（每个事务具有多条记录的表）条目的关键字段（和描述）必须汇总到一个记录/行中，如下所示：

[TRANSACTION_ID]           UUID 

[PARENT_PROCESS_NAME]     user friendly name of process code  

[PARENT_EXECUTION_ID]   Unique ID for each transaction execution this is used to group the multiple records 

[CREATED_TIME_STAMP]     Transactional duration timestamp  Beginning to End  

[PROCESS_INDICATOR]     ** standard method for determining status and outcome value applied to field 

[ERROR_TYPE]   < field content required to be propagated to summary record >  
[PROCESS_ID]    
[ENVIRONMENT_ID] 
[PROCESS_NAME] 
[BATCH_SEQ_NO] 
[BATCH_COUNT]  
[PROCESS_EXEC_SEQ] 
[NODE_ID]      
[EXECUTION_MESSAGE] 
 
[ATTRIBUTE4]                Since the summarization methodology will be run at scheduled intervals daily  This field has been allocated (in Audit Table) to act as a flag for rows previously processed and will be set upon successful completion each transactional summary 

** = 过程指示符标识符 E = 已完成 SS = 已开始 X = 错误 在此字段中，摘要记录的此字段只能有 3 种状态： 已完成，无错误（隐含）
已完成，无错误 待定

在此处输入图像描述

我可以按parent_ execution_ID选择并与事务关联的行数进行分组。 我无法将每笔交易的多行合二为一，每条汇总记录定义处理时间、持续时间、状态或结果逻辑。或何时在审核表上插入/设置已处理的标志