Advertisement
Guest User

Untitled

a guest
Aug 21st, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. Milestone Name 2016/2017 2017/2018 2018/2019 2019/2020 2020/2021
  2.  
  3. Construction ...$ ...$ ...$ ...$ ...$
  4.  
  5. Security ...$ ...$ ...$ ...$ ...$
  6.  
  7. Travel ...$ ...$ ...$ ...$ ...$
  8.  
  9. SELECT *
  10. FROM (
  11. SELECT names.MilestoneName
  12. , FY = CONVERT(varchar(4), YEAR(dates.MilestoneStartDate))
  13. + '-' + CONVERT(varchar(4), YEAR(dates.MilestoneEndDate))
  14. , [Money Spent(Budgeted)] = CONVERT(varchar(20), details.MoneySpent)
  15. + ' (' + CONVERT(varchar(20), details.MoneyBudgeted) + ')'
  16. FROM dbo.MilestoneDetails details
  17. INNER JOIN dbo.MilestoneDates dates
  18. ON details.MilestoneDateID = dates.MilestoneDateID
  19. INNER JOIN dbo.MilestoneNames names
  20. ON details.MilestoneID = names.MilestoneID
  21. ) src
  22. PIVOT (
  23. MAX(src.[Money Spent(Budgeted)])
  24. FOR
  25. src.FY IN (
  26. [2015-2016]
  27. , [2016-2017]
  28. , [2017-2018]
  29. )
  30. ) pvt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement