求优化SQL语句。在线急等。50分奉上。
SELECT yy_code AS visit_area, RTRIM
((SELECT description
FROM pls..yingye_base
WHERE yy_code = A.yy_code)) AS 营业所, COUNT(*) AS visit_count,
DATEDIFF(Day, '2007/01/21 ', '2007/02/20 ') + 1 -
(SELECT COUNT(*)
FROM PUNCH..AM13
WHERE riqi > = '2007/01/21 ' AND riqi <= '2007/02/20 ') - 1 AS visit_days,
(SELECT COUNT(*) 'tempcolsaleddd '
FROM (SELECT slsman
FROM crm_visit
WHERE 1 = 1 AND CONVERT(char(10), visit_date, 111) > = '2007/01/21 ' AND
CONVERT(char(10), visit_date, 111) <= '2007/02/20 ' AND
yy_code = A.yy_code AND slsman IN
(SELECT slsman
FROM pls..yingye_slsman
WHERE haspart = 0)
GROUP BY slsman) CCCCDDDDD) AS '业务员数 ',
(SELECT COUNT(*) 'tempcol '
FROM (SELECT yy_code, slsman, visit_date
FROM crm_visit
WHERE 1 = 1 AND CONVERT(char(10), visit_date, 111) > = '2007/01/21 ' AND
CONVERT(char(10), visit_date, 111) <= '2007/02/20 ' AND
yy_code = A.yy_code AND visit_date NOT IN
(SELECT riqi
FROM PUNCH..AM13
WHERE riqi > = '2007/01/21 ' AND riqi <= '2007/02/20 ') AND
slsman IN
(SELECT slsman
FROM pls..yingye_slsman
WHERE haspart = 0)
GROUP BY yy_code, slsman, visit_date) ddddd) AS 实际反馈数
FROM crm_visit A
WHERE (1 = 1) AND (CONVERT(char(10), visit_date, 111) > = '2007/01/21 ') AND
(CONVERT(char(10), visit_date, 111) <= '2007/02/20 ') AND (visit_date NOT IN
(SELECT riqi
FROM PUNCH..AM13
WHERE riqi > = '2007/01/21 ' AND riqi <= '2007/02/20 ')) AND (slsman IN
(SELECT slsman
FROM pls..yingye_slsman
WHERE haspart = 0))
GROUP BY yy_code
ORDER BY yy_code
[解决办法]
我，呵呵
