workflow.Workflow_SqlUsp - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of workflow.Workflow_SqlUsp - V
Column Name	Data Type	NULL?
SqlUsp	`nvarchar(max)`	`NOT NULL`
UspList	`nvarchar(max)`	`NULL`
Workflow_id	`int`	`NOT NULL`
Workflow_Name	`nvarchar(500)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_Workflow_SqlUsp__1

IndexSemanticGroup: no_group
- [column-Workflow_id]; int
PK, Unique, Real: 0, 0, 0

Column Details

_

SqlUsp

nvarchar(max)

NOT NULL

UspList

nvarchar(max)

NULL

Referenced Columns

workflow.Workflow_UspList.UspList

Workflow_id

int

NOT NULL

Referenced Columns

workflow.Workflow_UspList.Workflow_id

Workflow_Name

nvarchar(500)

NULL

Referenced Columns

workflow.Workflow_UspList.Workflow_Name

sql_modules_definition

workflow.Workflow_SqlUsp - V script

CREATE View workflow.Workflow_SqlUsp
As
Select
    T1.Workflow_id
  , T1.Workflow_Name
  , SqlUsp =
  --
  Concat (
             'USE  ['
           , dwhdb.dwh_database_name
           , ']'
           , Char ( 13 ) + Char ( 10 )
           , 'GO'
           , Char ( 13 ) + Char ( 10 )
           , 'CREATE OR ALTER PROCEDURE '
           , 'dbo'
           , '.'
           , 'usp_'
           , T1.Workflow_Name
           , Char ( 13 ) + Char ( 10 )
           , '@execution_instance_guid UNIQUEIDENTIFIER = NULL --SSIS system variable ExecutionInstanceGUID could be used, any other unique guid is also fine. If NULL, then NEWID() is used to create one'
           , Char ( 13 ) + Char ( 10 )
           , 'AS'
           , Char ( 13 ) + Char ( 10 )
           , 'Begin'
           , Char ( 13 ) + Char ( 10 )
           , 'IF @execution_instance_guid IS Null SET @execution_instance_guid = NEWID();'
           , Char ( 13 ) + Char ( 10 )
           , Char ( 13 ) + Char ( 10 )
           , T1.UspList
           , Char ( 13 ) + Char ( 10 )
           , 'End'
           , Char ( 13 ) + Char ( 10 )
           , 'GO'
         )
  , T1.UspList
From
    workflow.Workflow_UspList             As T1
    Cross Join config.ftv_dwh_database () As dwhdb