how can i change my query so it display results like cross tab or pivot format?
SELECT [Location Code], SUM(Quantity)
FROM dbo.[CQC$Item Ledger Entry]
WHERE [Item No_] = '10438'
AND [Location Code] IN ('10', '20', '90', '95')
GROUP BY [Location Code]
not all locations have quantities all times but ideally I would like my results to be like (using results as screen shot shows):
10 20 90 95
Any help would be great.
thank you so much.