logs.ExecutionLog_parent - V
type: V ( view ), modify_date: 2022-06-30 18:23:13
RepoObject_guid: BD90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
parent_current_execution_guid
parent_current_execution_guid |
|
|
parent_proc_fullname
parent_proc_fullname |
|
|
(concat(quotename([proc_schema_name]),'.',quotename([proc_name])))
sql_modules_definition
logs.ExecutionLog_parent - V script
CREATE View [logs].[ExecutionLog_parent]
As
Select
T1.id
, T1.parent_execution_log_id
, parent_current_execution_guid = parent.current_execution_guid
, parent_proc_id = parent.proc_id
, parent_proc_schema_name = parent.proc_schema_name
, parent_proc_name = parent.proc_name
, parent_step_id = parent.step_id
, parent_step_name = parent.step_name
, parent_created_dt = parent.created_dt
, parent_parameter_01 = parent.parameter_01
, parent_parameter_02 = parent.parameter_02
, parent_parameter_03 = parent.parameter_03
, parent_parameter_04 = parent.parameter_04
, parent_parameter_05 = parent.parameter_05
, parent_parameter_06 = parent.parameter_06
, parent_parameter_07 = parent.parameter_07
, parent_parameter_08 = parent.parameter_08
, parent_parameter_09 = parent.parameter_09
, parent_parameter_10 = parent.parameter_10
, parent_parameter_11 = parent.parameter_11
, parent_parameter_12 = parent.parameter_12
, parent_parameter_13 = parent.parameter_13
, parent_parameter_14 = parent.parameter_14
, parent_parameter_15 = parent.parameter_15
, parent_parameter_16 = parent.parameter_16
, parent_parameter_17 = parent.parameter_17
, parent_parameter_18 = parent.parameter_18
, parent_parameter_19 = parent.parameter_19
, parent_parameter_20 = parent.parameter_20
, parent_proc_fullname = Concat(QuoteName(parent.[proc_schema_name]),'.',QuoteName(parent.[proc_name])) --proc_fullname
From
logs.ExecutionLog As T1
Left Join
logs.ExecutionLog As parent
On
parent.id = T1.parent_execution_log_id
Where
Not parent.id Is Null