ssas.model_json_3161_tables_descriptions_StrAgg - V
type: V ( view ), modify_date: 2022-09-08 16:27:47
RepoObject_guid: 1FFF988B-480B-EC11-8516-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_model_json_3161_tables_descriptions_StrAgg__1
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3161_tables_descriptions_StrAgg__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
ssas.model_json_3161_tables_descriptions_StrAgg - V script
CREATE View ssas.model_json_3161_tables_descriptions_StrAgg
As
Select
T1.databasename
, T1.tables_name
, T1.RepoObject_guid
, descriptions_StrAgg = String_Agg ( Cast(T1.Value As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
Try_Cast(T1.[Key] As Int))
From
ssas.model_json_316_tables_descriptions_multiline As T1
Group By
T1.databasename
, T1.tables_name
, T1.RepoObject_guid