有没有更好的办法?
Haten 2008-05-06 05:04:22 CREATE TABLE #TB1
(
ID VARCHAR(10),
NAME VARCHAR(10),
TYPE VARCHAR(10)
)
CREATE TABLE #TB2
(
ID VARCHAR(10),
NAME VARCHAR(10),
TYPE VARCHAR(10),
RESULT INT
)
INSERT INTO #TB1
SELECT '0001','ZHANGSAN','1'
UNION
SELECT '0002','LISI','2'
INSERT INTO #TB2
SELECT '0001','ZHANGSAN','1',100
UNION
SELECT '0001','ZHANGSAN','1',200
UNION
SELECT '0001','ZHANGSAN','1',300
SELECT A.ID AS ID,A.NAME,A.TYPE,SUM(B.RESULT)
FROM #TB1 A LEFT JOIN #TB2 B ON A.ID=B.ID AND A.NAME=B.NAME AND A.TYPE=B.TYPE GROUP BY A.ID,A.NAME,A.TYPE
DROP TABLE #TB1
DROP TABLE #TB2
其中 #TB1,#TB2分别有几十万条记录,这个写法太慢了,一下就把服务器搞定了,呵呵 有没有更好的办法?