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

databasename

nvarchar(128)

NOT NULL

PosFrom

bigint

NULL

PosFromWhere

bigint

NULL

RepoObject_guid

uniqueidentifier

NOT NULL

StringFrom

nvarchar(max)

NULL

tables_name

nvarchar(128)

NOT NULL

tables_partitions_name

nvarchar(500)

NULL

tables_partitions_source_dataSource

nvarchar(500)

NULL

tables_partitions_source_expression

nvarchar(max)

NULL

tables_partitions_source_name

nvarchar(500)

NULL

tables_partitions_source_query

nvarchar(max)

NULL

tables_partitions_source_query_ja

nvarchar(max)

NULL

tables_partitions_source_type

nvarchar(500)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_313111_tables_partitions_source_stringfrom

References

Referenced Objects

Referencing Objects

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
Referenced Columns
Referencing Columns

PosFrom

PosFrom

bigint

NULL
Referenced Columns
Referencing Columns

PosFromWhere

PosFromWhere

bigint

NULL
Referenced Columns
Referencing Columns

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL
Referenced Columns
Referencing Columns

StringFrom

StringFrom

nvarchar(max)

NULL
Referencing Columns

tables_name

tables_name

nvarchar(128)

NOT NULL
Referenced Columns
Referencing Columns

tables_partitions_name

tables_partitions_name

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

tables_partitions_source_dataSource

tables_partitions_source_dataSource

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

tables_partitions_source_expression

tables_partitions_source_expression

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

tables_partitions_source_name

tables_partitions_source_name

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

tables_partitions_source_query

tables_partitions_source_query

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

tables_partitions_source_query_ja

tables_partitions_source_query_ja

nvarchar(max)

NULL
Referenced Columns
Referencing Columns

tables_partitions_source_type

tables_partitions_source_type

nvarchar(500)

NULL
Referenced Columns
Referencing Columns

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
sql