ssas.model_json_313111_tables_partitions_source_StringFrom - V

type: V ( view ), modify_date: 2021-09-28 18:15:31

RepoObject_guid: B208A66B-7A20-EC11-8524-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_313111_tables_partitions_source_stringfrom

Columns

Table 1. Columns of ssas.model_json_313111_tables_partitions_source_StringFrom - V
PK Column Name Data Type NULL? ID

nvarchar(128)

NOT NULL

bigint

NULL

bigint

NULL

uniqueidentifier

NOT NULL

nvarchar(max)

NULL

nvarchar(128)

NOT NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_313111_tables_partitions_source_stringfrom

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_313111_tables_partitions_source_stringfrom

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_313111_tables_partitions_source_stringfrom

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_313111_tables_partitions_source_stringfrom

Column Reference Diagram

entity_1_1_colref-ssas.model_json_313111_tables_partitions_source_stringfrom

Indexes

idx_model_json_313111_tables_partitions_source_StringFrom__1

idx_model_json_313111_tables_partitions_source_StringFrom__2

idx_model_json_313111_tables_partitions_source_StringFrom__3

idx_model_json_313111_tables_partitions_source_StringFrom__4

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

StringFrom

StringFrom

nvarchar(max)

NULL

tables_name

tables_name

nvarchar(128)

NOT NULL

tables_partitions_name

tables_partitions_name

nvarchar(500)

NULL

tables_partitions_source_dataSource

tables_partitions_source_dataSource

nvarchar(500)

NULL

tables_partitions_source_expression

tables_partitions_source_expression

nvarchar(max)

NULL

tables_partitions_source_name

tables_partitions_source_name

nvarchar(500)

NULL

tables_partitions_source_query

tables_partitions_source_query

nvarchar(max)

NULL

tables_partitions_source_query_ja

tables_partitions_source_query_ja

nvarchar(max)

NULL

tables_partitions_source_type

tables_partitions_source_type

nvarchar(500)

NULL

sql_modules_definition

ssas.model_json_313111_tables_partitions_source_StringFrom - V script
CREATE View ssas.model_json_313111_tables_partitions_source_StringFrom
As
Select
    databasename
  , tables_name
  , RepoObject_guid
  , tables_partitions_name
  , tables_partitions_source_name
  , tables_partitions_source_dataSource
  , tables_partitions_source_expression
  , tables_partitions_source_query
  , tables_partitions_source_query_ja
  , tables_partitions_source_type
  , PosFrom
  , PosFromWhere
  , StringFrom = Trim (   Case
                              When PosFrom > 0
                                  Then
                                  Case
                                      When PosFromWhere > PosFrom
                                          Then
                                          Substring (
                                                        tables_partitions_source_query
                                                      , PosFrom + 6
                                                      , PosFromWhere - PosFrom - 6
                                                    )
                                      Else
                                          Substring (
                                                        tables_partitions_source_query
                                                      , PosFrom + 6
                                                      , Len ( tables_partitions_source_query ) - PosFrom - 5
                                                    )
                                  End
                          End
                      )
From
    ssas.model_json_31311_tables_partitions_source_PosFrom