DECLARE @beforSellNum float;
SELECT @beforSellNum=SUM(sellprice*verifiednum) FROM orderDetailsNum WHERE clientID=42 AND factorytime<'2016-02-10 17:18:48'; SELECT @beforSell
DECLARE @beforSellNum float;
SELECT @beforSellNum=SUM(sellprice*verifiednum) FROM orderDetailsNum WHERE clientID=42 AND factorytime<'2016-02-10 17:18:48'; SELECT @beforSell