Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question I have a table which have fields like fieldname and fieldvalue. I am trying to turn this table into another format. For example, I have
Tag: opensql
Query and Pivot Column for the last last 3 Years SQL
My need is to retrieve sell data from and pivot the last three years and sum the quantities. See example below. I wonder how to do it. I read that SQL pivot is the way to go, but I can’t figure out …