Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Milestone Name 2016/2017 2017/2018 2018/2019 2019/2020 2020/2021
- Construction ...$ ...$ ...$ ...$ ...$
- Security ...$ ...$ ...$ ...$ ...$
- Travel ...$ ...$ ...$ ...$ ...$
- SELECT *
- FROM (
- SELECT names.MilestoneName
- , FY = CONVERT(varchar(4), YEAR(dates.MilestoneStartDate))
- + '-' + CONVERT(varchar(4), YEAR(dates.MilestoneEndDate))
- , [Money Spent(Budgeted)] = CONVERT(varchar(20), details.MoneySpent)
- + ' (' + CONVERT(varchar(20), details.MoneyBudgeted) + ')'
- FROM dbo.MilestoneDetails details
- INNER JOIN dbo.MilestoneDates dates
- ON details.MilestoneDateID = dates.MilestoneDateID
- INNER JOIN dbo.MilestoneNames names
- ON details.MilestoneID = names.MilestoneID
- ) src
- PIVOT (
- MAX(src.[Money Spent(Budgeted)])
- FOR
- src.FY IN (
- [2015-2016]
- , [2016-2017]
- , [2017-2018]
- )
- ) pvt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement