Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) AS Cnt
- FROM datamartend.dbo.Abandoned_Call_Dim /*3*/
- INNER JOIN measure /*149,871*/
- ON measure.Abandoned = Abandoned_Call_Dim.abandoned_value
- INNER JOIN DataMartEnd.dbo.Work_Type_Dim /*866*/
- ON measure.DBID = work_type_dim.MIG_Site_ID
- /*Key lookup*/
- AND Work_Type_Dim.Work_Type_Code = measure.Queue
- AND measure.StartTimeDate BETWEEN Work_Type_Dim.DimEffectiveStartDtm AND Work_Type_Dim.DimEffectiveEndDtm
- INNER JOIN datamartend.dbo.Site_Type_Dim /*19*/
- ON work_type_dim.MIG_Site_ID = Site_Type_Dim.Site_Type_Code
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement