Advertisement
Guest User

Untitled

a guest
Sep 17th, 2014
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. --Calculations portion of query
  2. SELECT
  3. FNL.*
  4. INTO
  5. #Final_Calc
  6. FROM
  7. (
  8. DECLARE @i INT
  9. SET @i = 0
  10.  
  11. WHILE (@StartDte + @i <= @EndDte)
  12. BEGIN
  13. SET @i = @i + 1
  14.  
  15. SELECT
  16. YEAR(ACD.WorkDte) AS WorkDte,
  17. 'LOB - ALL ACM' AS RptType,
  18. 'Month' AS RptLvl
  19. FROM
  20. #FinalResults ACD
  21. WHERE
  22. ACD.WorkDte BETWEEN @StartDte AND @StartDte + @i
  23. GROUP BY
  24. Year(ACD.WorkDte), ACD.LOB
  25. END
  26. GO) fnl
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement