改成这样:SELECT UserId,
UserName,
SUM(Amount) AS allBuyMoney,
FROM Cp_PrintOut WITH ( NOLOCK )
WHERE 1 = 1
AND ReceiveTime BETWEEN '2013-12-01 0:00:00'
AND '2014-1-5 0:00:00'
AND Status >2
option(hash group)
UserName,
SUM(Amount) AS allBuyMoney,
FROM Cp_PrintOut WITH ( NOLOCK )
WHERE 1 = 1
AND ReceiveTime BETWEEN '2013-12-01 0:00:00'
AND '2014-1-5 0:00:00'
AND Status >2
option(hash group)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货