Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tech-notes:sql:pivot [2022/09/22 13:20] – [Our Source Table] gerardorourketech-notes:sql:pivot [2022/09/22 13:21] (current) – [Pivot of our Source Table] gerardorourke
Line 80: Line 80:
 </code> </code>
  
-You can see above is a select * from our table Pivoted with the following line:+You can see above is a SELECT * of our **source** table Pivoted with below following line:
 <code sql>Pivot( Max(CallsQueuedNow) FOR TransferCallType IN ([CIQ_IVR],[CIQ_Transfer]) ) </code> <code sql>Pivot( Max(CallsQueuedNow) FOR TransferCallType IN ([CIQ_IVR],[CIQ_Transfer]) ) </code>
  
  • tech-notes/sql/pivot.1663849236.txt.gz
  • Last modified: 2022/09/22 13:20
  • by gerardorourke