Value |
Expression: "
/* SQL INSERT into DimFeeType from New Temp Table */
INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimFeeType]
(FeeTypeAK
,FeeTypeCode
,FeeType
,FeeCategoryCode
,FeeCategory
,FeeGroupCode
,FeeGroup
,RowIsCurrent
,RowStartDate
,RowEndDate)
SELECT FeeTypeAK
,FeeTypeCode
,FeeType
,FeeCategoryCode
,FeeCategory
,FeeGroupCode
,FeeGroup
,RowIsCurrent
,RowStartDate
,RowEndDate
FROM Staged_dbo_DimFeeType__New
"
/* SQL INSERT into DimFeeType from New Temp Table */
INSERT INTO [EnterpriseDW].[dbo].[DimFeeType]
(FeeTypeAK
,FeeTypeCode
,FeeType
,FeeCategoryCode
,FeeCategory
,FeeGroupCode
,FeeGroup
,RowIsCurrent
,RowStartDate
,RowEndDate)
SELECT FeeTypeAK
,FeeTypeCode
,FeeType
,FeeCategoryCode
,FeeCategory
,FeeGroupCode
,FeeGroup
,RowIsCurrent
,RowStartDate
,RowEndDate
FROM Staged_dbo_DimFeeType__New
|
Expression |
"
/* SQL INSERT into DimFeeType from New Temp Table */
INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimFeeType]
(FeeTypeAK
,FeeTypeCode
,FeeType
,FeeCategoryCode
,FeeCategory
,FeeGroupCode
,FeeGroup
,RowIsCurrent
,RowStartDate
,RowEndDate)
SELECT FeeTypeAK
,FeeTypeCode
,FeeType
,FeeCategoryCode
,FeeCategory
,FeeGroupCode
,FeeGroup
,RowIsCurrent
,RowStartDate
,RowEndDate
FROM Staged_dbo_DimFeeType__New
" |