SQL Server PIVOT - Magic isn't it

Ever wonders how you could present data via a select statement horizontally instead of vertically. When your columns come from the data you are retrieving from the select statement. The answer is simple in TSQL called the pivot keyword. All it would do is to use the data as the pivot to form the columns. Consider the simple schema of the employee: Product

• Name
• ID

Product Sales

• ID
• Agent ID
• Quantity
  

Agent

• Name
• ID

And lets say you want a result table which shows: Agent product year select a.name as 'Agent', p.name as "" from agent a inner join product_Sales pd on ps.agent_id=a.id inner join product p on p.id=ps.product_id PIVOT (SUM(Quantity) for Agent IN (Agent1, Agent2, Agent3)) AS pvt