uspgenerator.GeneratorUsp_StepList - V

Description

Examples

Entity Diagram

Columns

Table 1. Columns of uspgenerator.GeneratorUsp_StepList - V
Column Name	Data Type	NULL?
AdocStepList	`nvarchar(max)`	`NULL`
StepList	`nvarchar(max)`	`NULL`
usp_id	`int`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

uspgenerator.GeneratorUspStep_Sql - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_GeneratorUsp_StepList__1

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

Column Details

_

AdocStepList

nvarchar(max)

NULL

StepList

nvarchar(max)

NULL

Referencing Columns

usp_id

int

NOT NULL

Referenced Columns

uspgenerator.GeneratorUspStep_Sql.usp_id

sql_modules_definition

uspgenerator.GeneratorUsp_StepList - V script

/*
SQL for the list of all steps
*/
CREATE View uspgenerator.GeneratorUsp_StepList
As
Select
    us.usp_id
  , StepList     = String_Agg ( Concat ( Cast('' As NVarchar(Max)), us.SqlStep ), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                              us.RowNumber_PerUsp)
  , AdocStepList = String_Agg ( Concat ( Cast('' As NVarchar(Max)), us.AdocStep ), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                               us.RowNumber_PerUsp)
From
    uspgenerator.GeneratorUspStep_Sql As us
Group By
    us.usp_id