Differences

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

Link to this comparison view

Both sides previous revision Previous revision
vendors:cisco:uc:icm:sql:bucket [2020/10/02 08:12] – [Call Type Answered Custom Bucket Interval Report] gerardorourkevendors:cisco:uc:icm:sql:bucket [2020/10/02 08:12] (current) – [Call Type Abandoned in IVR Custom Bucket Interval Report] gerardorourke
Line 128: Line 128:
  
 FROM TEMP_TABLE2 T2 FROM TEMP_TABLE2 T2
-JOIN Call_Type (nolock) on (T2.CallTypeID = Call_Type.CallTypeID) 
 ) AS T PIVOT (MAX(BucketCount) FOR BucketInterval IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS PIVOT_TABLE ) AS T PIVOT (MAX(BucketCount) FOR BucketInterval IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS PIVOT_TABLE
 ) )
  • vendors/cisco/uc/icm/sql/bucket.1601622721.txt.gz
  • Last modified: 2020/10/02 08:12
  • by gerardorourke