select [Month], Company
, convert(decimal(14,4), [BillableQuantity]) AS BQ
, convert(decimal(14,4), [BilledAmount] as BA
, convert(decimal(14,4), [SalesTax]) as ST
select [Month], Company, [Type], [Value]
unpivot ([Value] for [Type] in ([BQ], [BA], [ST])) u
-- final select (pvt)
pivot (sum([Value]) for [Month] in ([January],...,[December])) p
Open in new window
Author Closing Comment
Hassle-free live chat software re-imagined for business growth. 2 users, always free.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Connect with top rated Experts
23 Experts available now in Live!
Get 1:1 Help Now
Join our community for more solutions or to ask questions.
For immediate help use Live now!