Anonymous

          SELECT                 COUNT(DISTINCT sm.InvoiceNumber)    AS Sales,                si.Name                      AS NAME,                CONVERT(CHAR(11), sm.OrderDate) AS LineDate,                COUNT(DISTINCT ri.call_id)   AS Incoming,                COUNT(DISTINCT ri2.call_id)  AS Outgoing,                si.Location AS Area                 FROM  SorMasterRep sm                 LEFT  JOIN SalInitials si ON sm.AlternateKey = si.Initials                 LEFT  JOIN OPENQUERY(PHONELOG, 'SELECT                                                 e.Name     as name,                                                                     c.call_id  as call_id                                                  FROM extension e                                                  INNER JOIN call c ON e.extension_id = c.extension_id                                                  INNER JOIN calltype t ON t.calltype_id = c.calltype_id                                                   AND c.calldate BETWEEN ''04-11-26'' AND ''2004-11-27''                                                   AND t.letter IN (''I'')                                                  ') ri ON                                                   (ri.name COLLATE Latin1_General_BIN) =                                                   (si.Name COLLATE Latin1_General_BIN)                                                                  LEFT  JOIN OPENQUERY(PHONELOG, 'SELECT                                                 e.name    as name,                                                  c.call_id as call_id                                                  FROM extension e                                                  INNER JOIN call c ON e.extension_id = c.extension_id                                                  INNER JOIN calltype t ON t.calltype_id = c.calltype_id                                                   AND c.calldate BETWEEN ''04-11-26'' AND ''2004-11-27''                                                   AND t.letter IN (''O'')                                                 ') ri2 ON                                                   (ri2.name COLLATE Latin1_General_BIN) =                                                   (ri.name COLLATE Latin1_General_BIN)                                                                   WHERE sm.OrderDate = 'Nov 26 2004'                   AND si.Name IS NOT NULL                    GROUP BY                     si.Location,                     sm.OrderDate,                     si.Name                      ORDER BY                       si.Location,                       COUNT(DISTINCT si.Location) DESC,                       COUNT(DISTINCT sm.InvoiceNumber) DESC