| Name |
RemoveObsoleteStudentReceiptRows |
| Value |
 Expression: "
/* Remove Student Receipt Rows from DimStudentReceipt for Old Students */
DELETE StRec
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentReceipt] AS StRec WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StRec.StudentId = OldSt.OldStudentIdAK
)
"
/* Remove Student Receipt Rows from DimStudentReceipt for Old Students */
DELETE StRec
FROM
[EnterpriseDW].[dbo].[DimStudentReceipt] AS StRec WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StRec.StudentId = OldSt.OldStudentIdAK
)
|
| Value Type |
String |
| Description |
|
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::RemoveObsoleteStudentReceiptRows |
| Evaluate As Expression |
True |
| Expression |
"
/* Remove Student Receipt Rows from DimStudentReceipt for Old Students */
DELETE StRec
FROM
" + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudentReceipt] AS StRec WHERE StudentId IN
(
SELECT OldStudentIdAK
FROM dbo.Obsolete_DimStudent as OldSt
WHERE StRec.StudentId = OldSt.OldStudentIdAK
)
" |
| ID |
3f632ad3-949c-4435-891d-65d0d07bc125 |
| Raise Changed Event |
False |
Properties
