Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
vendors:cisco:uc:icm:sql:bucket [2020/10/02 08:10] – gerardorourkevendors:cisco:uc:icm:sql:bucket [2020/10/02 08:12] (current) – [Call Type Abandoned in IVR Custom Bucket Interval Report] gerardorourke
Line 52: Line 52:
  
 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
 ) )
Line 82: Line 81:
 ===== Call Type Abandoned in IVR Custom Bucket Interval Report ===== ===== Call Type Abandoned in IVR Custom Bucket Interval Report =====
 <code sql> <code sql>
-        SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON +SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON 
 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    
Line 129: 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.1601622601.txt.gz
  • Last modified: 2020/10/02 08:10
  • by gerardorourke