Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Calculations portion of query
- SELECT
- FNL.*
- INTO
- #Final_Calc
- FROM
- (
- DECLARE @i INT
- SET @i = 0
- WHILE (@StartDte + @i <= @EndDte)
- BEGIN
- SET @i = @i + 1
- SELECT
- YEAR(ACD.WorkDte) AS WorkDte,
- 'LOB - ALL ACM' AS RptType,
- 'Month' AS RptLvl
- FROM
- #FinalResults ACD
- WHERE
- ACD.WorkDte BETWEEN @StartDte AND @StartDte + @i
- GROUP BY
- Year(ACD.WorkDte), ACD.LOB
- END
- GO) fnl
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement