| Name |
SQLUpdateRelativeDay |
| Value |
 Expression: "
DECLARE @CurrentDayDate datetime = '" + @[User::CurrentDayDate] + "'
UPDATE Staged_dbo_DimTerm
SET RelativeDay = CAST(@CurrentDayDate - Staged_dbo_DimTerm.TermStartDate AS int)
FROM Staged_dbo_DimTerm
WHERE StagedTermSK <> -1
"
DECLARE @CurrentDayDate datetime = '2016-03-04'
UPDATE Staged_dbo_DimTerm
SET RelativeDay = CAST(@CurrentDayDate - Staged_dbo_DimTerm.TermStartDate AS int)
FROM Staged_dbo_DimTerm
WHERE StagedTermSK <> -1
|
| Value Type |
String |
| Description |
This variable contains the SQL statement that will be used to update the relative day column in the Staged Dim Term table. |
| System Variable |
False |
| Namespace |
User |
| Qualified Name |
User::SQLUpdateRelativeDay |
| Evaluate As Expression |
True |
| Expression |
"
DECLARE @CurrentDayDate datetime = '" + @[User::CurrentDayDate] + "'
UPDATE Staged_dbo_DimTerm
SET RelativeDay = CAST(@CurrentDayDate - Staged_dbo_DimTerm.TermStartDate AS int)
FROM Staged_dbo_DimTerm
WHERE StagedTermSK <> -1
" |
| ID |
b40ffaeb-7db9-44dd-817f-04256dcd7558 |
| Raise Changed Event |
False |
Properties
