22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT COUNT(DISTINCT UserID) FROM ChangeMoneyInfo where ChangeTypeID=1 and ChangeTime>=Isnull(@DTime,ChangeTime) and ChangeTime<=Isnull(@DTimeEnd,ChangeTime)
SELECT COUNT(DISTINCT UserID)
FROM [ChangeMoneyInfo] a
WHERE ChangeTypeID = 1
AND NOT EXISTS ( SELECT 1
FROM [ChangeMoneyInfo] b
WHERE b.userid = a.userid
AND b.ChangeTypeID = 1
AND b.changetime < @DTime )
AND ChangeTime >= @DTime
AND ChangeTime <= @DTimeEnd
CID UserID UserName ChangeTypeID OldMoney ChangeMoney UserMoney Explain ChangeOrderID ChangeOrderNum PSTypeID ChangeTime
----------- ----------- -------------------------------------------------- ------------ --------------------- --------------------- --------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------- ----------- -----------------------
452 66666 dayingjia 1 50000.00 100.00 49900.00 下单 160858 20140102035_54b469 1 2014-01-02 11:43:18.237
453 66666 dayingjia 1 49900.00 100.00 49800.00 下单 160867 20140102036_cdc7f8 1 2014-01-02 11:53:16.137
454 66666 dayingjia 1 49800.00 126.00 49674.00 下单 160876 20140102036_ef47fa 1 2014-01-02 11:53:24.590
455 66666 dayingjia 1 49674.00 100.00 49574.00 下单 160885 20140113044_43ce5b 1 2014-01-13 13:13:16.997
456 66666 dayingjia 1 49574.00 18.00 49556.00 下单 160894 20140113044_9ee81e 1 2014-01-13 13:13:23.813
457 66666 dayingjia 1 49556.00 2.00 49554.00 下单 160903 20140114084_534bde 1 2014-01-14 19:52:33.863
458 66666 dayingjia 1 49554.00 60.00 49494.00 下单 160912 20140116035_b96368 1 2014-01-16 11:48:18.070
459 66666 dayingjia 1 49494.00 60.00 49434.00 下单 160921 20140116036_784fca 1 2014-01-16 11:48:35.110
460 66666 dayingjia 1 49434.00 2.00 49432.00 下单 160930 20140116036_609dd1 1 2014-01-16 11:48:45.203
461 66666 dayingjia 1 49432.00 2000.00 47432.00 下单 160939 20140116036_33c9d2 1 2014-01-16 11:48:56.787
462 66666 dayingjia 1 47432.00 1980.00 45452.00 下单 160948 20140116019_a270c0 1 2014-01-16 11:49:14.157
466 66666 dayingjia 1 45389.00 100.00 45289.00 下单 160957 20140120079_fac516 1 2014-01-20 18:59:10.507
467 66666 dayingjia 1 45289.00 100.00 45189.00 下单 160966 20140120080_e17e75 1 2014-01-20 18:59:10.513
468 66666 dayingjia 1 45189.00 100.00 45089.00 下单
SELECT COUNT(DISTINCT UserID)
FROM ChangeMoneyInfo a
WHERE ChangeTypeID = 1
AND ChangeTime >= @DTime
AND ChangeTime <= @DTimeEnd
AND NOT EXISTS(SELECT 1 FROM ChangeMoneyInfo
WHERE UserID=a.UserID AND ChangeTypeID = 1 AND ChangeTime<@DTime
)
SELECT COUNT(DISTINCT UserID)
FROM ChangeMoneyInfo
WHERE ChangeTypeID = 1
AND ChangeTime >= ISNULL(@DTime, ChangeTime)
AND ChangeTime <= ISNULL(@DTimeEnd, ChangeTime)
HAVING COUNT(DISTINCT UserID)=1