ssas.model_json_31321_tables_partitions_StringFrom - V

type: V ( view ), modify_date: 2021-09-28 17:42:25

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

Description

Examples

Entity Diagram

entity-ssas.model_json_31321_tables_partitions_stringfrom

Columns

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

nvarchar(128)

NOT NULL

bigint

NULL

bigint

NULL

bigint

NULL

uniqueidentifier

NOT NULL

nvarchar(max)

NULL

nvarchar(128)

NOT NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_31321_tables_partitions_stringfrom

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_31321_tables_partitions_stringfrom

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_31321_tables_partitions_stringfrom

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_31321_tables_partitions_stringfrom

Column Reference Diagram

entity_1_1_colref-ssas.model_json_31321_tables_partitions_stringfrom

Indexes

idx_model_json_31321_tables_partitions_StringFrom__1

idx_model_json_31321_tables_partitions_StringFrom__2

idx_model_json_31321_tables_partitions_StringFrom__3

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

PosFromDoublequota

PosFromDoublequota

bigint

NULL

PosFromWhere

PosFromWhere

bigint

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

StringFrom

StringFrom

nvarchar(max)

NULL

tables_name

tables_name

nvarchar(128)

NOT NULL

tables_partitions_annotations_ja

tables_partitions_annotations_ja

nvarchar(max)

NULL

tables_partitions_dataView

tables_partitions_dataView

nvarchar(500)

NULL

tables_partitions_mode

tables_partitions_mode

nvarchar(500)

NULL

tables_partitions_name

tables_partitions_name

nvarchar(500)

NULL

tables_partitions_source_j

tables_partitions_source_j

nvarchar(max)

NULL

sql_modules_definition

ssas.model_json_31321_tables_partitions_StringFrom - V script
CREATE VIEW [ssas].[model_json_31321_tables_partitions_StringFrom]
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 = Trim (   Case
                              When PosFrom > 0
                                  Then
                                  Case
                                      When PosFromWhere
                                           Between PosFrom And PosFromDoublequota
                                          Then
                                          Substring (
                                                        tables_partitions_source_j
                                                      , PosFrom + 6
                                                      , PosFromWhere - PosFrom - 6
                                                    )
                                      When PosFromDoublequota > PosFrom
                                          Then
                                          Substring (
                                                        tables_partitions_source_j
                                                      , PosFrom + 6
                                                      , PosFromDoublequota - PosFrom - 6
                                                    )
                                  End
                          End
                      )
From
    ssas.model_json_3132_tables_partitions_PosFrom