/********************************************************************************
*主题:SQLserver一道微软面试题目的解答
*说明:本文是个人学习的一些笔记和个人愚见
* 有很多地方你可能觉得有异议,欢迎一起讨论
*作者:Stephenzhou(阿蒙)
*日期: 2012.08.30
*Mail:szstephenzhou@163.com
*另外:转载请著名出处。
**********************************************************************************/
--2. 某银行有一百个用户,各有100$ ,
--某个账户某天如有支出则添加一条新记录,记录其余额。请自行设计表,
--一百天后,请输出每天所有账户的余额信息。
/*
看到这个题目挺有意思的,网上有个人也已经解答,是一个面试题目,他说后面没有面试上数据库工程师
我就没有心思看他的解答了。呵呵 自己根据这个题目写了点东西 希望对大家有帮助
可能有些地方注释让你不是很了解 如果不了解给我留言 我会耐心的给你解答
如果你有更好的解决办法 也可以告诉我。
*/
if OBJECT_ID('tb') is not null
drop table tb
go
create table tb(
username varchar(50),--用户名称
OutMoney int,--用了支出的金额
OutDate varchar(50)--用钱的时间
)
go
insert into tb values('user01',30,'2012-09-01')
insert into tb values('user01',12,'2012-09-01')
insert into tb values('user01',21,'2012-09-02')
insert into tb values('user01',32,'2012-09-04')
insert into tb values('user01',12,'2012-09-07')
insert into tb values('user01',42,'2012-09-09')
insert into tb values('user02',23,'2012-09-02')
insert into tb values('user02',65,'2012-09-04')
insert into tb values('user02',1,'2012-09-07')
insert into tb values('user02',3,'2012-09-10')
insert into tb values('user02',4,'2012-09-07')
insert into tb values('user03',4,'2012-09-07')
insert into tb values('user03',4,'2012-09-07')
insert into tb values('user03',3,'2012-01-02')
insert into tb values('user03',34,'2012-04-03')
insert into tb values('user03',43,'2012-02-3')
insert into tb values('user03',54,'2012-05-12')
insert into tb values('user03',84,'2012-10-11')
insert into tb values('user03',2,'2012-11-21')
insert into tb values('user03',32,'2012-05-3')
insert into tb values('user03',67,'2012-03-6')
insert into tb values('user03',31,'2012-04-07')
insert into tb values('user03',32,'2012-01-9')
insert into tb values('user03',12,'2012-02-3')
insert into tb values('user03',15,'2012-03-1')
insert into tb values('user03',21,'2012-06-3')
insert into tb values('user03',53,'2012-07-24')
insert into tb values('user03',23,'2012-08-16')
insert into tb values('user03',21,'2012-09-30')
--随便的插入了很多数据 用户user1 ,user2, user3 随机的插入了数据。不通的日期相同和不通的人消费记录。
select * from tb order by OutDate
/*
username OutMoney OutDate
-------------------------------------------------- ----------- --------------------------------------------------
user03 3 2012-01-02
user03 32 2012-01-9
user03 12 2012-02-3
user03 43 2012-02-3
user03 15 2012-03-1
user03 67 2012-03-6
user03 34 2012-04-03
user03 31 2012-04-07
user03 54 2012-05-12
user03 32 2012-05-3
user03 21 2012-06-3
user03 53 2012-07-24
user03 23 2012-08-16
user01 30 2012-09-01
user01 12 2012-09-01
user01 21 2012-09-02
user02 23 2012-09-02
user02 65 2012-09-04
user01 32 2012-09-04
user01 12 2012-09-07
user02 1 2012-09-07
user02 4 2012-09-07
user03 4 2012-09-07
user03 4 2012-09-07
user01 42 2012-09-09
user02 3 2012-09-10
user03 21 2012-09-30
user03 84 2012-10-11
user03 2 2012-11-21
(29 行受影响)
*/
--查询语句
declare @userMoney int
set @userMoney=100 --每个人都有100块 。
Declare @startdate datetime
declare @enddate datetime
select @enddate=MAX(OutDate) from tb
select @startdate=min(OutDate) from tb
--print convert(varchar(10), @enddate,120)
--print convert(varchar(10), @startdate,120)
; with cte
as
(
select *,ROW_NUMBER()over(partition by username order by Outdate)rn from (
select username,SUM(OutMoney) ErveyOut ,OutDate from tb group by username,OutDate)s
)
,ct
as
(
select *
from (
select *
,(
select top 1 fes.SumOut from (
select *,isnull((select SUM(ErveyOut) from cte t where c.rn>t.rn),c.ErveyOut) SumOut from cte c
)fes where Tu.Times= fes.OutDate and Tu.username=fes.username
)ffe
from (
select *
from (
select convert (varchar(10),DATEADD(dd,number,@startdate), 120 ) Times
from master..spt_values s where s.type='p' and
s.number >=0 and datediff(dd,DATEADD(dd,number,@startdate),@enddate)>=0 )m
left join (select distinct(username) from tb) f on 1=1 )Tu
)ee
)
select l.Times 时间,l.username as 用户,isnull(l.eet,0)as 已经支出的金额,(@userMoney- isnull(l.eet,0)) as 剩余金额 from (
select *,
(
case when t.ffe IS null then
(select top 1 ffe from ct c where c.Times<t.Times and c.username=t.username and c.ffe IS not null order by c.Times desc)
else t.ffe
end ) as eet
from ct t)l
-- 下结果
/*
时间 用户 已经支出的金额 剩余金额
---------- -------------------------------------------------- ----------- -----------
2012-01-02 user01 0 100
2012-01-02 user02 0 100
2012-01-02 user03 3 97
2012-01-03 user01 0 100
2012-01-03 user02 0 100
2012-01-03 user03 3 97
2012-01-04 user01 0 100
2012-01-04 user02 0 100
2012-01-04 user03 3 97
2012-01-05 user01 0 100
2012-01-05 user02 0 100
2012-01-05 user03 3 97
2012-01-06 user01 0 100
2012-01-06 user02 0 100
2012-01-06 user03 3 97
2012-01-07 user01 0 100
2012-01-07 user02 0 100
2012-01-07 user03 3 97
2012-01-08 user01 0 100
2012-01-08 user02 0 100
2012-01-08 user03 3 97
2012-01-09 user01 0 100
2012-01-09 user02 0 100
2012-01-09 user03 3 97
2012-01-10 user01 0 100
2012-01-10 user02 0 100
2012-01-10 user03 3 97
2012-01-11 user01 0 100
2012-01-11 user02 0 100
2012-01-11 user03 3 97
2012-01-12 user01 0 100
2012-01-12 user02 0 100
2012-01-12 user03 3 97
2012-01-13 user01 0 100
2012-01-13 user02 0 100
2012-01-13 user03 3 97
2012-01-14 user01 0 100
2012-01-14 user02 0 100
2012-01-14 user03 3 97
2012-01-15 user01 0 100
2012-01-15 user02 0 100
2012-01-15 user03 3 97
2012-01-16 user01 0 100
2012-01-16 user02 0 100
2012-01-16 user03 3 97
2012-01-17 user01 0 100
2012-01-17 user02 0 100
2012-01-17 user03 3 97
2012-01-18 user01 0 100
2012-01-18 user02 0 100
2012-01-18 user03 3 97
2012-01-19 user01 0 100
2012-01-19 user02 0 100
2012-01-19 user03 3 97
2012-01-20 user01 0 100
2012-01-20 user02 0 100
2012-01-20 user03 3 97
2012-01-21 user01 0 100
2012-01-21 user02 0 100
2012-01-21 user03 3 97
2012-01-22 user01 0 100
2012-01-22 user02 0 100
2012-01-22 user03 3 97
2012-01-23 user01 0 100
2012-01-23 user02 0 100
2012-01-23 user03 3 97
2012-01-24 user01 0 100
2012-01-24 user02 0 100
2012-01-24 user03 3 97
2012-01-25 user01 0 100
2012-01-25 user02 0 100
2012-01-25 user03 3 97
2012-01-26 user01 0 100
2012-01-26 user02 0 100
2012-01-26 user03 3 97
2012-01-27 user01 0 100
2012-01-27 user02 0 100
2012-01-27 user03 3 97
2012-01-28 user01 0 100
2012-01-28 user02 0 100
2012-01-28 user03 3 97
2012-01-29 user01 0 100
2012-01-29 user02 0 100
2012-01-29 user03 3 97
2012-01-30 user01 0 100
2012-01-30 user02 0 100
2012-01-30 user03 3 97
2012-01-31 user01 0 100
2012-01-31 user02 0 100
2012-01-31 user03 3 97
2012-02-01 user01 0 100
2012-02-01 user02 0 100
2012-02-01 user03 3 97
2012-02-02 user01 0 100
2012-02-02 user02 0 100
2012-02-02 user03 3 97
2012-02-03 user01 0 100
2012-02-03 user02 0 100
2012-02-03 user03 3 97
2012-02-04 user01 0 100
2012-02-04 user02 0 100
2012-02-04 user03 3 97
2012-02-05 user01 0 100
2012-02-05 user02 0 100
2012-02-05 user03 3 97
2012-02-06 user01 0 100
2012-02-06 user02 0 100
2012-02-06 user03 3 97
2012-02-07 user01 0 100
2012-02-07 user02 0 100
2012-02-07 user03 3 97
2012-02-08 user01 0 100
2012-02-08 user02 0 100
2012-02-08 user03 3 97
2012-02-09 user01 0 100
2012-02-09 user02 0 100
2012-02-09 user03 3 97
2012-02-10 user01 0 100
2012-02-10 user02 0 100
2012-02-10 user03 3 97
2012-02-11 user01 0 100
2012-02-11 user02 0 100
2012-02-11 user03 3 97
2012-02-12 user01 0 100
2012-02-12 user02 0 100
2012-02-12 user03 3 97
2012-02-13 user01 0 100
2012-02-13 user02 0 100
2012-02-13 user03 3 97
2012-02-14 user01 0 100
2012-02-14 user02 0 100
2012-02-14 user03 3 97
2012-02-15 user01 0 100
2012-02-15 user02 0 100
2012-02-15 user03 3 97
2012-02-16 user01 0 100
2012-02-16 user02 0 100
2012-02-16 user03 3 97
2012-02-17 user01 0 100
2012-02-17 user02 0 100
2012-02-17 user03 3 97
2012-02-18 user01 0 100
2012-02-18 user02 0 100
2012-02-18 user03 3 97
2012-02-19 user01 0 100
2012-02-19 user02 0 100
2012-02-19 user03 3 97
2012-02-20 user01 0 100
2012-02-20 user02 0 100
2012-02-20 user03 3 97
2012-02-21 user01 0 100
2012-02-21 user02 0 100
2012-02-21 user03 3 97
2012-02-22 user01 0 100
2012-02-22 user02 0 100
2012-02-22 user03 3 97
2012-02-23 user01 0 100
2012-02-23 user02 0 100
2012-02-23 user03 3 97
2012-02-24 user01 0 100
2012-02-24 user02 0 100
2012-02-24 user03 3 97
2012-02-25 user01 0 100
2012-02-25 user02 0 100
2012-02-25 user03 3 97
2012-02-26 user01 0 100
2012-02-26 user02 0 100
2012-02-26 user03 3 97
2012-02-27 user01 0 100
2012-02-27 user02 0 100
2012-02-27 user03 3 97
2012-02-28 user01 0 100
2012-02-28 user02 0 100
2012-02-28 user03 3 97
2012-02-29 user01 0 100
2012-02-29 user02 0 100
2012-02-29 user03 3 97
2012-03-01 user01 0 100
2012-03-01 user02 0 100
2012-03-01 user03 3 97
2012-03-02 user01 0 100
2012-03-02 user02 0 100
2012-03-02 user03 3 97
2012-03-03 user01 0 100
2012-03-03 user02 0 100
2012-03-03 user03 3 97
2012-03-04 user01 0 100
2012-03-04 user02 0 100
2012-03-04 user03 3 97
2012-03-05 user01 0 100
2012-03-05 user02 0 100
2012-03-05 user03 3 97
2012-03-06 user01 0 100
2012-03-06 user02 0 100
2012-03-06 user03 3 97
2012-03-07 user01 0 100
2012-03-07 user02 0 100
2012-03-07 user03 3 97
2012-03-08 user01 0 100
2012-03-08 user02 0 100
2012-03-08 user03 3 97
2012-03-09 user01 0 100
2012-03-09 user02 0 100
2012-03-09 user03 3 97
2012-03-10 user01 0 100
2012-03-10 user02 0 100
2012-03-10 user03 3 97
2012-03-11 user01 0 100
2012-03-11 user02 0 100
2012-03-11 user03 3 97
2012-03-12 user01 0 100
2012-03-12 user02 0 100
2012-03-12 user03 3 97
2012-03-13 user01 0 100
2012-03-13 user02 0 100
2012-03-13 user03 3 97
2012-03-14 user01 0 100
2012-03-14 user02 0 100
2012-03-14 user03 3 97
2012-03-15 user01 0 100
2012-03-15 user02 0 100
2012-03-15 user03 3 97
2012-03-16 user01 0 100
2012-03-16 user02 0 100
2012-03-16 user03 3 97
2012-03-17 user01 0 100
2012-03-17 user02 0 100
2012-03-17 user03 3 97
2012-03-18 user01 0 100
2012-03-18 user02 0 100
2012-03-18 user03 3 97
2012-03-19 user01 0 100
2012-03-19 user02 0 100
2012-03-19 user03 3 97
2012-03-20 user01 0 100
2012-03-20 user02 0 100
2012-03-20 user03 3 97
2012-03-21 user01 0 100
2012-03-21 user02 0 100
2012-03-21 user03 3 97
2012-03-22 user01 0 100
2012-03-22 user02 0 100
2012-03-22 user03 3 97
2012-03-23 user01 0 100
2012-03-23 user02 0 100
2012-03-23 user03 3 97
2012-03-24 user01 0 100
2012-03-24 user02 0 100
2012-03-24 user03 3 97
2012-03-25 user01 0 100
2012-03-25 user02 0 100
2012-03-25 user03 3 97
2012-03-26 user01 0 100
2012-03-26 user02 0 100
2012-03-26 user03 3 97
2012-03-27 user01 0 100
2012-03-27 user02 0 100
2012-03-27 user03 3 97
2012-03-28 user01 0 100
2012-03-28 user02 0 100
2012-03-28 user03 3 97
2012-03-29 user01 0 100
2012-03-29 user02 0 100
2012-03-29 user03 3 97
2012-03-30 user01 0 100
2012-03-30 user02 0 100
2012-03-30 user03 3 97
2012-03-31 user01 0 100
2012-03-31 user02 0 100
2012-03-31 user03 3 97
2012-04-01 user01 0 100
2012-04-01 user02 0 100
2012-04-01 user03 3 97
2012-04-02 user01 0 100
2012-04-02 user02 0 100
2012-04-02 user03 3 97
2012-04-03 user01 0 100
2012-04-03 user02 0 100
2012-04-03 user03 417 -317
2012-04-04 user01 0 100
2012-04-04 user02 0 100
2012-04-04 user03 417 -317
2012-04-05 user01 0 100
2012-04-05 user02 0 100
2012-04-05 user03 417 -317
2012-04-06 user01 0 100
2012-04-06 user02 0 100
2012-04-06 user03 417 -317
2012-04-07 user01 0 100
2012-04-07 user02 0 100
2012-04-07 user03 451 -351
2012-04-08 user01 0 100
2012-04-08 user02 0 100
2012-04-08 user03 451 -351
2012-04-09 user01 0 100
2012-04-09 user02 0 100
2012-04-09 user03 451 -351
2012-04-10 user01 0 100
2012-04-10 user02 0 100
2012-04-10 user03 451 -351
2012-04-11 user01 0 100
2012-04-11 user02 0 100
2012-04-11 user03 451 -351
2012-04-12 user01 0 100
2012-04-12 user02 0 100
2012-04-12 user03 451 -351
2012-04-13 user01 0 100
2012-04-13 user02 0 100
2012-04-13 user03 451 -351
2012-04-14 user01 0 100
2012-04-14 user02 0 100
2012-04-14 user03 451 -351
2012-04-15 user01 0 100
2012-04-15 user02 0 100
2012-04-15 user03 451 -351
2012-04-16 user01 0 100
2012-04-16 user02 0 100
2012-04-16 user03 451 -351
2012-04-17 user01 0 100
2012-04-17 user02 0 100
2012-04-17 user03 451 -351
2012-04-18 user01 0 100
2012-04-18 user02 0 100
2012-04-18 user03 451 -351
2012-04-19 user01 0 100
2012-04-19 user02 0 100
2012-04-19 user03 451 -351
2012-04-20 user01 0 100
2012-04-20 user02 0 100
2012-04-20 user03 451 -351
2012-04-21 user01 0 100
2012-04-21 user02 0 100
2012-04-21 user03 451 -351
2012-04-22 user01 0 100
2012-04-22 user02 0 100
2012-04-22 user03 451 -351
2012-04-23 user01 0 100
2012-04-23 user02 0 100
2012-04-23 user03 451 -351
2012-04-24 user01 0 100
2012-04-24 user02 0 100
2012-04-24 user03 451 -351
2012-04-25 user01 0 100
2012-04-25 user02 0 100
2012-04-25 user03 451 -351
2012-04-26 user01 0 100
2012-04-26 user02 0 100
2012-04-26 user03 451 -351
2012-04-27 user01 0 100
2012-04-27 user02 0 100
2012-04-27 user03 451 -351
2012-04-28 user01 0 100
2012-04-28 user02 0 100
2012-04-28 user03 451 -351
2012-04-29 user01 0 100
2012-04-29 user02 0 100
2012-04-29 user03 451 -351
2012-04-30 user01 0 100
2012-04-30 user02 0 100
2012-04-30 user03 451 -351
2012-05-01 user01 0 100
2012-05-01 user02 0 100
2012-05-01 user03 451 -351
2012-05-02 user01 0 100
2012-05-02 user02 0 100
2012-05-02 user03 451 -351
2012-05-03 user01 0 100
2012-05-03 user02 0 100
2012-05-03 user03 451 -351
2012-05-04 user01 0 100
2012-05-04 user02 0 100
2012-05-04 user03 451 -351
2012-05-05 user01 0 100
2012-05-05 user02 0 100
2012-05-05 user03 451 -351
2012-05-06 user01 0 100
2012-05-06 user02 0 100
2012-05-06 user03 451 -351
2012-05-07 user01 0 100
2012-05-07 user02 0 100
2012-05-07 user03 451 -351
2012-05-08 user01 0 100
2012-05-08 user02 0 100
2012-05-08 user03 451 -351
2012-05-09 user01 0 100
2012-05-09 user02 0 100
2012-05-09 user03 451 -351
2012-05-10 user01 0 100
2012-05-10 user02 0 100
2012-05-10 user03 451 -351
2012-05-11 user01 0 100
2012-05-11 user02 0 100
2012-05-11 user03 451 -351
2012-05-12 user01 0 100
2012-05-12 user02 0 100
2012-05-12 user03 482 -382
2012-05-13 user01 0 100
2012-05-13 user02 0 100
2012-05-13 user03 482 -382
2012-05-14 user01 0 100
2012-05-14 user02 0 100
2012-05-14 user03 482 -382
2012-05-15 user01 0 100
2012-05-15 user02 0 100
2012-05-15 user03 482 -382
2012-05-16 user01 0 100
2012-05-16 user02 0 100
2012-05-16 user03 482 -382
2012-05-17 user01 0 100
2012-05-17 user02 0 100
2012-05-17 user03 482 -382
2012-05-18 user01 0 100
2012-05-18 user02 0 100
2012-05-18 user03 482 -382
2012-05-19 user01 0 100
2012-05-19 user02 0 100
2012-05-19 user03 482 -382
2012-05-20 user01 0 100
2012-05-20 user02 0 100
2012-05-20 user03 482 -382
2012-05-21 user01 0 100
2012-05-21 user02 0 100
2012-05-21 user03 482 -382
2012-05-22 user01 0 100
2012-05-22 user02 0 100
2012-05-22 user03 482 -382
2012-05-23 user01 0 100
2012-05-23 user02 0 100
2012-05-23 user03 482 -382
2012-05-24 user01 0 100
2012-05-24 user02 0 100
2012-05-24 user03 482 -382
2012-05-25 user01 0 100
2012-05-25 user02 0 100
2012-05-25 user03 482 -382
2012-05-26 user01 0 100
2012-05-26 user02 0 100
2012-05-26 user03 482 -382
2012-05-27 user01 0 100
2012-05-27 user02 0 100
2012-05-27 user03 482 -382
2012-05-28 user01 0 100
2012-05-28 user02 0 100
2012-05-28 user03 482 -382
2012-05-29 user01 0 100
2012-05-29 user02 0 100
2012-05-29 user03 482 -382
2012-05-30 user01 0 100
2012-05-30 user02 0 100
2012-05-30 user03 482 -382
2012-05-31 user01 0 100
2012-05-31 user02 0 100
2012-05-31 user03 482 -382
2012-06-01 user01 0 100
2012-06-01 user02 0 100
2012-06-01 user03 482 -382
2012-06-02 user01 0 100
2012-06-02 user02 0 100
2012-06-02 user03 482 -382
2012-06-03 user01 0 100
2012-06-03 user02 0 100
2012-06-03 user03 482 -382
2012-06-04 user01 0 100
2012-06-04 user02 0 100
2012-06-04 user03 482 -382
2012-06-05 user01 0 100
2012-06-05 user02 0 100
2012-06-05 user03 482 -382
2012-06-06 user01 0 100
2012-06-06 user02 0 100
2012-06-06 user03 482 -382
2012-06-07 user01 0 100
2012-06-07 user02 0 100
2012-06-07 user03 482 -382
2012-06-08 user01 0 100
2012-06-08 user02 0 100
2012-06-08 user03 482 -382
2012-06-09 user01 0 100
2012-06-09 user02 0 100
2012-06-09 user03 482 -382
2012-06-10 user01 0 100
2012-06-10 user02 0 100
2012-06-10 user03 482 -382
2012-06-11 user01 0 100
2012-06-11 user02 0 100
2012-06-11 user03 482 -382
2012-06-12 user01 0 100
2012-06-12 user02 0 100
2012-06-12 user03 482 -382
2012-06-13 user01 0 100
2012-06-13 user02 0 100
2012-06-13 user03 482 -382
2012-06-14 user01 0 100
2012-06-14 user02 0 100
2012-06-14 user03 482 -382
2012-06-15 user01 0 100
2012-06-15 user02 0 100
2012-06-15 user03 482 -382
2012-06-16 user01 0 100
2012-06-16 user02 0 100
2012-06-16 user03 482 -382
2012-06-17 user01 0 100
2012-06-17 user02 0 100
2012-06-17 user03 482 -382
2012-06-18 user01 0 100
2012-06-18 user02 0 100
2012-06-18 user03 482 -382
2012-06-19 user01 0 100
2012-06-19 user02 0 100
2012-06-19 user03 482 -382
2012-06-20 user01 0 100
2012-06-20 user02 0 100
2012-06-20 user03 482 -382
2012-06-21 user01 0 100
2012-06-21 user02 0 100
2012-06-21 user03 482 -382
2012-06-22 user01 0 100
2012-06-22 user02 0 100
2012-06-22 user03 482 -382
2012-06-23 user01 0 100
2012-06-23 user02 0 100
2012-06-23 user03 482 -382
2012-06-24 user01 0 100
2012-06-24 user02 0 100
2012-06-24 user03 482 -382
2012-06-25 user01 0 100
2012-06-25 user02 0 100
2012-06-25 user03 482 -382
2012-06-26 user01 0 100
2012-06-26 user02 0 100
2012-06-26 user03 482 -382
2012-06-27 user01 0 100
2012-06-27 user02 0 100
2012-06-27 user03 482 -382
2012-06-28 user01 0 100
2012-06-28 user02 0 100
2012-06-28 user03 482 -382
2012-06-29 user01 0 100
2012-06-29 user02 0 100
2012-06-29 user03 482 -382
2012-06-30 user01 0 100
2012-06-30 user02 0 100
2012-06-30 user03 482 -382
2012-07-01 user01 0 100
2012-07-01 user02 0 100
2012-07-01 user03 482 -382
2012-07-02 user01 0 100
2012-07-02 user02 0 100
2012-07-02 user03 482 -382
2012-07-03 user01 0 100
2012-07-03 user02 0 100
2012-07-03 user03 482 -382
2012-07-04 user01 0 100
2012-07-04 user02 0 100
2012-07-04 user03 482 -382
2012-07-05 user01 0 100
2012-07-05 user02 0 100
2012-07-05 user03 482 -382
2012-07-06 user01 0 100
2012-07-06 user02 0 100
2012-07-06 user03 482 -382
2012-07-07 user01 0 100
2012-07-07 user02 0 100
2012-07-07 user03 482 -382
2012-07-08 user01 0 100
2012-07-08 user02 0 100
2012-07-08 user03 482 -382
2012-07-09 user01 0 100
2012-07-09 user02 0 100
2012-07-09 user03 482 -382
2012-07-10 user01 0 100
2012-07-10 user02 0 100
2012-07-10 user03 482 -382
2012-07-11 user01 0 100
2012-07-11 user02 0 100
2012-07-11 user03 482 -382
2012-07-12 user01 0 100
2012-07-12 user02 0 100
2012-07-12 user03 482 -382
2012-07-13 user01 0 100
2012-07-13 user02 0 100
2012-07-13 user03 482 -382
2012-07-14 user01 0 100
2012-07-14 user02 0 100
2012-07-14 user03 482 -382
2012-07-15 user01 0 100
2012-07-15 user02 0 100
2012-07-15 user03 482 -382
2012-07-16 user01 0 100
2012-07-16 user02 0 100
2012-07-16 user03 482 -382
2012-07-17 user01 0 100
2012-07-17 user02 0 100
2012-07-17 user03 482 -382
2012-07-18 user01 0 100
2012-07-18 user02 0 100
2012-07-18 user03 482 -382
2012-07-19 user01 0 100
2012-07-19 user02 0 100
2012-07-19 user03 482 -382
2012-07-20 user01 0 100
2012-07-20 user02 0 100
2012-07-20 user03 482 -382
2012-07-21 user01 0 100
2012-07-21 user02 0 100
2012-07-21 user03 482 -382
2012-07-22 user01 0 100
2012-07-22 user02 0 100
2012-07-22 user03 482 -382
2012-07-23 user01 0 100
2012-07-23 user02 0 100
2012-07-23 user03 482 -382
2012-07-24 user01 0 100
2012-07-24 user02 0 100
2012-07-24 user03 589 -489
2012-07-25 user01 0 100
2012-07-25 user02 0 100
2012-07-25 user03 589 -489
2012-07-26 user01 0 100
2012-07-26 user02 0 100
2012-07-26 user03 589 -489
2012-07-27 user01 0 100
2012-07-27 user02 0 100
2012-07-27 user03 589 -489
2012-07-28 user01 0 100
2012-07-28 user02 0 100
2012-07-28 user03 589 -489
2012-07-29 user01 0 100
2012-07-29 user02 0 100
2012-07-29 user03 589 -489
2012-07-30 user01 0 100
2012-07-30 user02 0 100
2012-07-30 user03 589 -489
2012-07-31 user01 0 100
2012-07-31 user02 0 100
2012-07-31 user03 589 -489
2012-08-01 user01 0 100
2012-08-01 user02 0 100
2012-08-01 user03 589 -489
2012-08-02 user01 0 100
2012-08-02 user02 0 100
2012-08-02 user03 589 -489
2012-08-03 user01 0 100
2012-08-03 user02 0 100
2012-08-03 user03 589 -489
2012-08-04 user01 0 100
2012-08-04 user02 0 100
2012-08-04 user03 589 -489
2012-08-05 user01 0 100
2012-08-05 user02 0 100
2012-08-05 user03 589 -489
2012-08-06 user01 0 100
2012-08-06 user02 0 100
2012-08-06 user03 589 -489
2012-08-07 user01 0 100
2012-08-07 user02 0 100
2012-08-07 user03 589 -489
2012-08-08 user01 0 100
2012-08-08 user02 0 100
2012-08-08 user03 589 -489
2012-08-09 user01 0 100
2012-08-09 user02 0 100
2012-08-09 user03 589 -489
2012-08-10 user01 0 100
2012-08-10 user02 0 100
2012-08-10 user03 589 -489
2012-08-11 user01 0 100
2012-08-11 user02 0 100
2012-08-11 user03 589 -489
2012-08-12 user01 0 100
2012-08-12 user02 0 100
2012-08-12 user03 589 -489
2012-08-13 user01 0 100
2012-08-13 user02 0 100
2012-08-13 user03 589 -489
2012-08-14 user01 0 100
2012-08-14 user02 0 100
2012-08-14 user03 589 -489
2012-08-15 user01 0 100
2012-08-15 user02 0 100
2012-08-15 user03 589 -489
2012-08-16 user01 0 100
2012-08-16 user02 0 100
2012-08-16 user03 642 -542
2012-08-17 user01 0 100
2012-08-17 user02 0 100
2012-08-17 user03 642 -542
2012-08-18 user01 0 100
2012-08-18 user02 0 100
2012-08-18 user03 642 -542
2012-08-19 user01 0 100
2012-08-19 user02 0 100
2012-08-19 user03 642 -542
2012-08-20 user01 0 100
2012-08-20 user02 0 100
2012-08-20 user03 642 -542
2012-08-21 user01 0 100
2012-08-21 user02 0 100
2012-08-21 user03 642 -542
2012-08-22 user01 0 100
2012-08-22 user02 0 100
2012-08-22 user03 642 -542
2012-08-23 user01 0 100
2012-08-23 user02 0 100
2012-08-23 user03 642 -542
2012-08-24 user01 0 100
2012-08-24 user02 0 100
2012-08-24 user03 642 -542
2012-08-25 user01 0 100
2012-08-25 user02 0 100
2012-08-25 user03 642 -542
2012-08-26 user01 0 100
2012-08-26 user02 0 100
2012-08-26 user03 642 -542
2012-08-27 user01 0 100
2012-08-27 user02 0 100
2012-08-27 user03 642 -542
2012-08-28 user01 0 100
2012-08-28 user02 0 100
2012-08-28 user03 642 -542
2012-08-29 user01 0 100
2012-08-29 user02 0 100
2012-08-29 user03 642 -542
2012-08-30 user01 0 100
2012-08-30 user02 0 100
2012-08-30 user03 642 -542
2012-08-31 user01 0 100
2012-08-31 user02 0 100
2012-08-31 user03 642 -542
2012-09-01 user01 42 58
2012-09-01 user02 0 100
2012-09-01 user03 642 -542
2012-09-02 user01 68 32
2012-09-02 user02 23 77
2012-09-02 user03 642 -542
2012-09-03 user01 68 32
2012-09-03 user02 23 77
2012-09-03 user03 642 -542
2012-09-04 user01 186 -86
2012-09-04 user02 68 32
2012-09-04 user03 642 -542
2012-09-05 user01 186 -86
2012-09-05 user02 68 32
2012-09-05 user03 642 -542
2012-09-06 user01 186 -86
2012-09-06 user02 68 32
2012-09-06 user03 642 -542
2012-09-07 user01 278 -178
2012-09-07 user02 186 -86
2012-09-07 user03 665 -565
2012-09-08 user01 278 -178
2012-09-08 user02 186 -86
2012-09-08 user03 665 -565
2012-09-09 user01 308 -208
2012-09-09 user02 186 -86
2012-09-09 user03 665 -565
2012-09-10 user01 308 -208
2012-09-10 user02 278 -178
2012-09-10 user03 665 -565
2012-09-11 user01 308 -208
2012-09-11 user02 278 -178
2012-09-11 user03 665 -565
2012-09-12 user01 308 -208
2012-09-12 user02 278 -178
2012-09-12 user03 665 -565
2012-09-13 user01 308 -208
2012-09-13 user02 278 -178
2012-09-13 user03 665 -565
2012-09-14 user01 308 -208
2012-09-14 user02 278 -178
2012-09-14 user03 665 -565
2012-09-15 user01 308 -208
2012-09-15 user02 278 -178
2012-09-15 user03 665 -565
2012-09-16 user01 308 -208
2012-09-16 user02 278 -178
2012-09-16 user03 665 -565
2012-09-17 user01 308 -208
2012-09-17 user02 278 -178
2012-09-17 user03 665 -565
2012-09-18 user01 308 -208
2012-09-18 user02 278 -178
2012-09-18 user03 665 -565
2012-09-19 user01 308 -208
2012-09-19 user02 278 -178
2012-09-19 user03 665 -565
2012-09-20 user01 308 -208
2012-09-20 user02 278 -178
2012-09-20 user03 665 -565
2012-09-21 user01 308 -208
2012-09-21 user02 278 -178
2012-09-21 user03 665 -565
2012-09-22 user01 308 -208
2012-09-22 user02 278 -178
2012-09-22 user03 665 -565
2012-09-23 user01 308 -208
2012-09-23 user02 278 -178
2012-09-23 user03 665 -565
2012-09-24 user01 308 -208
2012-09-24 user02 278 -178
2012-09-24 user03 665 -565
2012-09-25 user01 308 -208
2012-09-25 user02 278 -178
2012-09-25 user03 665 -565
2012-09-26 user01 308 -208
2012-09-26 user02 278 -178
2012-09-26 user03 665 -565
2012-09-27 user01 308 -208
2012-09-27 user02 278 -178
2012-09-27 user03 665 -565
2012-09-28 user01 308 -208
2012-09-28 user02 278 -178
2012-09-28 user03 665 -565
2012-09-29 user01 308 -208
2012-09-29 user02 278 -178
2012-09-29 user03 665 -565
2012-09-30 user01 308 -208
2012-09-30 user02 278 -178
2012-09-30 user03 673 -573
2012-10-01 user01 308 -208
2012-10-01 user02 278 -178
2012-10-01 user03 673 -573
2012-10-02 user01 308 -208
2012-10-02 user02 278 -178
2012-10-02 user03 673 -573
2012-10-03 user01 308 -208
2012-10-03 user02 278 -178
2012-10-03 user03 673 -573
2012-10-04 user01 308 -208
2012-10-04 user02 278 -178
2012-10-04 user03 673 -573
2012-10-05 user01 308 -208
2012-10-05 user02 278 -178
2012-10-05 user03 673 -573
2012-10-06 user01 308 -208
2012-10-06 user02 278 -178
2012-10-06 user03 673 -573
2012-10-07 user01 308 -208
2012-10-07 user02 278 -178
2012-10-07 user03 673 -573
2012-10-08 user01 308 -208
2012-10-08 user02 278 -178
2012-10-08 user03 673 -573
2012-10-09 user01 308 -208
2012-10-09 user02 278 -178
2012-10-09 user03 673 -573
2012-10-10 user01 308 -208
2012-10-10 user02 278 -178
2012-10-10 user03 673 -573
2012-10-11 user01 308 -208
2012-10-11 user02 278 -178
2012-10-11 user03 694 -594
2012-10-12 user01 308 -208
2012-10-12 user02 278 -178
2012-10-12 user03 694 -594
2012-10-13 user01 308 -208
2012-10-13 user02 278 -178
2012-10-13 user03 694 -594
2012-10-14 user01 308 -208
2012-10-14 user02 278 -178
2012-10-14 user03 694 -594
2012-10-15 user01 308 -208
2012-10-15 user02 278 -178
2012-10-15 user03 694 -594
2012-10-16 user01 308 -208
2012-10-16 user02 278 -178
2012-10-16 user03 694 -594
2012-10-17 user01 308 -208
2012-10-17 user02 278 -178
2012-10-17 user03 694 -594
2012-10-18 user01 308 -208
2012-10-18 user02 278 -178
2012-10-18 user03 694 -594
2012-10-19 user01 308 -208
2012-10-19 user02 278 -178
2012-10-19 user03 694 -594
2012-10-20 user01 308 -208
2012-10-20 user02 278 -178
2012-10-20 user03 694 -594
2012-10-21 user01 308 -208
2012-10-21 user02 278 -178
2012-10-21 user03 694 -594
2012-10-22 user01 308 -208
2012-10-22 user02 278 -178
2012-10-22 user03 694 -594
2012-10-23 user01 308 -208
2012-10-23 user02 278 -178
2012-10-23 user03 694 -594
2012-10-24 user01 308 -208
2012-10-24 user02 278 -178
2012-10-24 user03 694 -594
2012-10-25 user01 308 -208
2012-10-25 user02 278 -178
2012-10-25 user03 694 -594
2012-10-26 user01 308 -208
2012-10-26 user02 278 -178
2012-10-26 user03 694 -594
2012-10-27 user01 308 -208
2012-10-27 user02 278 -178
2012-10-27 user03 694 -594
2012-10-28 user01 308 -208
2012-10-28 user02 278 -178
2012-10-28 user03 694 -594
2012-10-29 user01 308 -208
2012-10-29 user02 278 -178
2012-10-29 user03 694 -594
2012-10-30 user01 308 -208
2012-10-30 user02 278 -178
2012-10-30 user03 694 -594
2012-10-31 user01 308 -208
2012-10-31 user02 278 -178
2012-10-31 user03 694 -594
2012-11-01 user01 308 -208
2012-11-01 user02 278 -178
2012-11-01 user03 694 -594
2012-11-02 user01 308 -208
2012-11-02 user02 278 -178
2012-11-02 user03 694 -594
2012-11-03 user01 308 -208
2012-11-03 user02 278 -178
2012-11-03 user03 694 -594
2012-11-04 user01 308 -208
2012-11-04 user02 278 -178
2012-11-04 user03 694 -594
2012-11-05 user01 308 -208
2012-11-05 user02 278 -178
2012-11-05 user03 694 -594
2012-11-06 user01 308 -208
2012-11-06 user02 278 -178
2012-11-06 user03 694 -594
2012-11-07 user01 308 -208
2012-11-07 user02 278 -178
2012-11-07 user03 694 -594
2012-11-08 user01 308 -208
2012-11-08 user02 278 -178
2012-11-08 user03 694 -594
2012-11-09 user01 308 -208
2012-11-09 user02 278 -178
2012-11-09 user03 694 -594
2012-11-10 user01 308 -208
2012-11-10 user02 278 -178
2012-11-10 user03 694 -594
2012-11-11 user01 308 -208
2012-11-11 user02 278 -178
2012-11-11 user03 694 -594
2012-11-12 user01 308 -208
2012-11-12 user02 278 -178
2012-11-12 user03 694 -594
2012-11-13 user01 308 -208
2012-11-13 user02 278 -178
2012-11-13 user03 694 -594
2012-11-14 user01 308 -208
2012-11-14 user02 278 -178
2012-11-14 user03 694 -594
2012-11-15 user01 308 -208
2012-11-15 user02 278 -178
2012-11-15 user03 694 -594
2012-11-16 user01 308 -208
2012-11-16 user02 278 -178
2012-11-16 user03 694 -594
2012-11-17 user01 308 -208
2012-11-17 user02 278 -178
2012-11-17 user03 694 -594
2012-11-18 user01 308 -208
2012-11-18 user02 278 -178
2012-11-18 user03 694 -594
2012-11-19 user01 308 -208
2012-11-19 user02 278 -178
2012-11-19 user03 694 -594
2012-11-20 user01 308 -208
2012-11-20 user02 278 -178
2012-11-20 user03 694 -594
2012-11-21 user01 308 -208
2012-11-21 user02 278 -178
2012-11-21 user03 778 -678
(975 行受影响)
*/
*作者:Stephenzhou(阿蒙)
*日期: 2012.08.30
*Mail:szstephenzhou@163.com
*另外:转载请著名出处。
*博客地址:http://blog.csdn.net/szstephenzhou