ssas.model_json_3132111_tables_partitions_Part123 - V
type: V ( view ), modify_date: 2021-09-28 17:42:25
RepoObject_guid: B808A66B-7A20-EC11-8524-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_model_json_3132111_tables_partitions_Part123__1
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
[column-tables_partitions_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3132111_tables_partitions_Part123__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_3132111_tables_partitions_Part123__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
ssas.model_json_3132111_tables_partitions_Part123 - V script
CREATE VIEW [ssas].[model_json_3132111_tables_partitions_Part123]
As
Select
databasename
, tables_name
, RepoObject_guid
, tables_partitions_name
, tables_partitions_annotations_ja
, tables_partitions_dataView
, tables_partitions_mode
, tables_partitions_source_j
, PosFrom
, PosFromDoublequota
, PosFromWhere
, StringFrom
, PosDot1
, PosDot2
--why we don't use STRING_SPLIT()
--The output rows might be in any order. The order is not guaranteed to match the order of the substrings in the input string.
, Part1 = Iif(PosDot1 > 2 And PosDot2 > PosDot1, Left(StringFrom, PosDot1 - 1), Null)
, Part2 = Case
When PosDot1 > 2
Then
Case
When PosDot2 > PosDot1
Then
Substring ( StringFrom, PosDot1 + 1, PosDot2 - PosDot1 - 1 )
Else
Left(StringFrom, PosDot1 - 1)
End
End
, Part3 = Case
When PosDot1 > 2
Then
Case
When PosDot2 > PosDot1
Then
Right(StringFrom, Len ( StringFrom ) - PosDot2)
Else
Right(StringFrom, Len ( StringFrom ) - PosDot1)
End
End
From
ssas.model_json_313211_tables_partitions_PosDot
sql