SQLserver一路微软的面试题 有趣真有趣

/********************************************************************************     *主题：SQLserver一道微软面试题目的解答   *说明：本文是个人学习的一些笔记和个人愚见     *      有很多地方你可能觉得有异议，欢迎一起讨论         *作者：Stephenzhou(阿蒙)     *日期: 2012.08.30     *Mail:[email protected]     *另外：转载请著名出处。    **********************************************************************************/   --2.	某银行有一百个用户，各有100$ ,--某个账户某天如有支出则添加一条新记录，记录其余额。请自行设计表，--一百天后，请输出每天所有账户的余额信息。/*看到这个题目挺有意思的，网上有个人也已经解答，是一个面试题目，他说后面没有面试上数据库工程师 我就没有心思看他的解答了。呵呵 自己根据这个题目写了点东西 希望对大家有帮助可能有些地方注释让你不是很了解 如果不了解给我留言 我会耐心的给你解答如果你有更好的解决办法  也可以告诉我。*/if OBJECT_ID('tb') is not nulldrop table tbgocreate table tb(username varchar(50),--用户名称OutMoney int,--用了支出的金额OutDate varchar(50)--用钱的时间)goinsert 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-02user03                                             32          2012-01-9user03                                             12          2012-02-3user03                                             43          2012-02-3user03                                             15          2012-03-1user03                                             67          2012-03-6user03                                             34          2012-04-03user03                                             31          2012-04-07user03                                             54          2012-05-12user03                                             32          2012-05-3user03                                             21          2012-06-3user03                                             53          2012-07-24user03                                             23          2012-08-16user01                                             30          2012-09-01user01                                             12          2012-09-01user01                                             21          2012-09-02user02                                             23          2012-09-02user02                                             65          2012-09-04user01                                             32          2012-09-04user01                                             12          2012-09-07user02                                             1           2012-09-07user02                                             4           2012-09-07user03                                             4           2012-09-07user03                                             4           2012-09-07user01                                             42          2012-09-09user02                                             3           2012-09-10user03                                             21          2012-09-30user03                                             84          2012-10-11user03                                             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           1002012-01-02 user02                                             0           1002012-01-02 user03                                             3           972012-01-03 user01                                             0           1002012-01-03 user02                                             0           1002012-01-03 user03                                             3           972012-01-04 user01                                             0           1002012-01-04 user02                                             0           1002012-01-04 user03                                             3           972012-01-05 user01                                             0           1002012-01-05 user02                                             0           1002012-01-05 user03                                             3           972012-01-06 user01                                             0           1002012-01-06 user02                                             0           1002012-01-06 user03                                             3           972012-01-07 user01                                             0           1002012-01-07 user02                                             0           1002012-01-07 user03                                             3           972012-01-08 user01                                             0           1002012-01-08 user02                                             0           1002012-01-08 user03                                             3           972012-01-09 user01                                             0           1002012-01-09 user02                                             0           1002012-01-09 user03                                             3           972012-01-10 user01                                             0           1002012-01-10 user02                                             0           1002012-01-10 user03                                             3           972012-01-11 user01                                             0           1002012-01-11 user02                                             0           1002012-01-11 user03                                             3           972012-01-12 user01                                             0           1002012-01-12 user02                                             0           1002012-01-12 user03                                             3           972012-01-13 user01                                             0           1002012-01-13 user02                                             0           1002012-01-13 user03                                             3           972012-01-14 user01                                             0           1002012-01-14 user02                                             0           1002012-01-14 user03                                             3           972012-01-15 user01                                             0           1002012-01-15 user02                                             0           1002012-01-15 user03                                             3           972012-01-16 user01                                             0           1002012-01-16 user02                                             0           1002012-01-16 user03                                             3           972012-01-17 user01                                             0           1002012-01-17 user02                                             0           1002012-01-17 user03                                             3           972012-01-18 user01                                             0           1002012-01-18 user02                                             0           1002012-01-18 user03                                             3           972012-01-19 user01                                             0           1002012-01-19 user02                                             0           1002012-01-19 user03                                             3           972012-01-20 user01                                             0           1002012-01-20 user02                                             0           1002012-01-20 user03                                             3           972012-01-21 user01                                             0           1002012-01-21 user02                                             0           1002012-01-21 user03                                             3           972012-01-22 user01                                             0           1002012-01-22 user02                                             0           1002012-01-22 user03                                             3           972012-01-23 user01                                             0           1002012-01-23 user02                                             0           1002012-01-23 user03                                             3           972012-01-24 user01                                             0           1002012-01-24 user02                                             0           1002012-01-24 user03                                             3           972012-01-25 user01                                             0           1002012-01-25 user02                                             0           1002012-01-25 user03                                             3           972012-01-26 user01                                             0           1002012-01-26 user02                                             0           1002012-01-26 user03                                             3           972012-01-27 user01                                             0           1002012-01-27 user02                                             0           1002012-01-27 user03                                             3           972012-01-28 user01                                             0           1002012-01-28 user02                                             0           1002012-01-28 user03                                             3           972012-01-29 user01                                             0           1002012-01-29 user02                                             0           1002012-01-29 user03                                             3           972012-01-30 user01                                             0           1002012-01-30 user02                                             0           1002012-01-30 user03                                             3           972012-01-31 user01                                             0           1002012-01-31 user02                                             0           1002012-01-31 user03                                             3           972012-02-01 user01                                             0           1002012-02-01 user02                                             0           1002012-02-01 user03                                             3           972012-02-02 user01                                             0           1002012-02-02 user02                                             0           1002012-02-02 user03                                             3           972012-02-03 user01                                             0           1002012-02-03 user02                                             0           1002012-02-03 user03                                             3           972012-02-04 user01                                             0           1002012-02-04 user02                                             0           1002012-02-04 user03                                             3           972012-02-05 user01                                             0           1002012-02-05 user02                                             0           1002012-02-05 user03                                             3           972012-02-06 user01                                             0           1002012-02-06 user02                                             0           1002012-02-06 user03                                             3           972012-02-07 user01                                             0           1002012-02-07 user02                                             0           1002012-02-07 user03                                             3           972012-02-08 user01                                             0           1002012-02-08 user02                                             0           1002012-02-08 user03                                             3           972012-02-09 user01                                             0           1002012-02-09 user02                                             0           1002012-02-09 user03                                             3           972012-02-10 user01                                             0           1002012-02-10 user02                                             0           1002012-02-10 user03                                             3           972012-02-11 user01                                             0           1002012-02-11 user02                                             0           1002012-02-11 user03                                             3           972012-02-12 user01                                             0           1002012-02-12 user02                                             0           1002012-02-12 user03                                             3           972012-02-13 user01                                             0           1002012-02-13 user02                                             0           1002012-02-13 user03                                             3           972012-02-14 user01                                             0           1002012-02-14 user02                                             0           1002012-02-14 user03                                             3           972012-02-15 user01                                             0           1002012-02-15 user02                                             0           1002012-02-15 user03                                             3           972012-02-16 user01                                             0           1002012-02-16 user02                                             0           1002012-02-16 user03                                             3           972012-02-17 user01                                             0           1002012-02-17 user02                                             0           1002012-02-17 user03                                             3           972012-02-18 user01                                             0           1002012-02-18 user02                                             0           1002012-02-18 user03                                             3           972012-02-19 user01                                             0           1002012-02-19 user02                                             0           1002012-02-19 user03                                             3           972012-02-20 user01                                             0           1002012-02-20 user02                                             0           1002012-02-20 user03                                             3           972012-02-21 user01                                             0           1002012-02-21 user02                                             0           1002012-02-21 user03                                             3           972012-02-22 user01                                             0           1002012-02-22 user02                                             0           1002012-02-22 user03                                             3           972012-02-23 user01                                             0           1002012-02-23 user02                                             0           1002012-02-23 user03                                             3           972012-02-24 user01                                             0           1002012-02-24 user02                                             0           1002012-02-24 user03                                             3           972012-02-25 user01                                             0           1002012-02-25 user02                                             0           1002012-02-25 user03                                             3           972012-02-26 user01                                             0           1002012-02-26 user02                                             0           1002012-02-26 user03                                             3           972012-02-27 user01                                             0           1002012-02-27 user02                                             0           1002012-02-27 user03                                             3           972012-02-28 user01                                             0           1002012-02-28 user02                                             0           1002012-02-28 user03                                             3           972012-02-29 user01                                             0           1002012-02-29 user02                                             0           1002012-02-29 user03                                             3           972012-03-01 user01                                             0           1002012-03-01 user02                                             0           1002012-03-01 user03                                             3           972012-03-02 user01                                             0           1002012-03-02 user02                                             0           1002012-03-02 user03                                             3           972012-03-03 user01                                             0           1002012-03-03 user02                                             0           1002012-03-03 user03                                             3           972012-03-04 user01                                             0           1002012-03-04 user02                                             0           1002012-03-04 user03                                             3           972012-03-05 user01                                             0           1002012-03-05 user02                                             0           1002012-03-05 user03                                             3           972012-03-06 user01                                             0           1002012-03-06 user02                                             0           1002012-03-06 user03                                             3           972012-03-07 user01                                             0           1002012-03-07 user02                                             0           1002012-03-07 user03                                             3           972012-03-08 user01                                             0           1002012-03-08 user02                                             0           1002012-03-08 user03                                             3           972012-03-09 user01                                             0           1002012-03-09 user02                                             0           1002012-03-09 user03                                             3           972012-03-10 user01                                             0           1002012-03-10 user02                                             0           1002012-03-10 user03                                             3           972012-03-11 user01                                             0           1002012-03-11 user02                                             0           1002012-03-11 user03                                             3           972012-03-12 user01                                             0           1002012-03-12 user02                                             0           1002012-03-12 user03                                             3           972012-03-13 user01                                             0           1002012-03-13 user02                                             0           1002012-03-13 user03                                             3           972012-03-14 user01                                             0           1002012-03-14 user02                                             0           1002012-03-14 user03                                             3           972012-03-15 user01                                             0           1002012-03-15 user02                                             0           1002012-03-15 user03                                             3           972012-03-16 user01                                             0           1002012-03-16 user02                                             0           1002012-03-16 user03                                             3           972012-03-17 user01                                             0           1002012-03-17 user02                                             0           1002012-03-17 user03                                             3           972012-03-18 user01                                             0           1002012-03-18 user02                                             0           1002012-03-18 user03                                             3           972012-03-19 user01                                             0           1002012-03-19 user02                                             0           1002012-03-19 user03                                             3           972012-03-20 user01                                             0           1002012-03-20 user02                                             0           1002012-03-20 user03                                             3           972012-03-21 user01                                             0           1002012-03-21 user02                                             0           1002012-03-21 user03                                             3           972012-03-22 user01                                             0           1002012-03-22 user02                                             0           1002012-03-22 user03                                             3           972012-03-23 user01                                             0           1002012-03-23 user02                                             0           1002012-03-23 user03                                             3           972012-03-24 user01                                             0           1002012-03-24 user02                                             0           1002012-03-24 user03                                             3           972012-03-25 user01                                             0           1002012-03-25 user02                                             0           1002012-03-25 user03                                             3           972012-03-26 user01                                             0           1002012-03-26 user02                                             0           1002012-03-26 user03                                             3           972012-03-27 user01                                             0           1002012-03-27 user02                                             0           1002012-03-27 user03                                             3           972012-03-28 user01                                             0           1002012-03-28 user02                                             0           1002012-03-28 user03                                             3           972012-03-29 user01                                             0           1002012-03-29 user02                                             0           1002012-03-29 user03                                             3           972012-03-30 user01                                             0           1002012-03-30 user02                                             0           1002012-03-30 user03                                             3           972012-03-31 user01                                             0           1002012-03-31 user02                                             0           1002012-03-31 user03                                             3           972012-04-01 user01                                             0           1002012-04-01 user02                                             0           1002012-04-01 user03                                             3           972012-04-02 user01                                             0           1002012-04-02 user02                                             0           1002012-04-02 user03                                             3           972012-04-03 user01                                             0           1002012-04-03 user02                                             0           1002012-04-03 user03                                             417         -3172012-04-04 user01                                             0           1002012-04-04 user02                                             0           1002012-04-04 user03                                             417         -3172012-04-05 user01                                             0           1002012-04-05 user02                                             0           1002012-04-05 user03                                             417         -3172012-04-06 user01                                             0           1002012-04-06 user02                                             0           1002012-04-06 user03                                             417         -3172012-04-07 user01                                             0           1002012-04-07 user02                                             0           1002012-04-07 user03                                             451         -3512012-04-08 user01                                             0           1002012-04-08 user02                                             0           1002012-04-08 user03                                             451         -3512012-04-09 user01                                             0           1002012-04-09 user02                                             0           1002012-04-09 user03                                             451         -3512012-04-10 user01                                             0           1002012-04-10 user02                                             0           1002012-04-10 user03                                             451         -3512012-04-11 user01                                             0           1002012-04-11 user02                                             0           1002012-04-11 user03                                             451         -3512012-04-12 user01                                             0           1002012-04-12 user02                                             0           1002012-04-12 user03                                             451         -3512012-04-13 user01                                             0           1002012-04-13 user02                                             0           1002012-04-13 user03                                             451         -3512012-04-14 user01                                             0           1002012-04-14 user02                                             0           1002012-04-14 user03                                             451         -3512012-04-15 user01                                             0           1002012-04-15 user02                                             0           1002012-04-15 user03                                             451         -3512012-04-16 user01                                             0           1002012-04-16 user02                                             0           1002012-04-16 user03                                             451         -3512012-04-17 user01                                             0           1002012-04-17 user02                                             0           1002012-04-17 user03                                             451         -3512012-04-18 user01                                             0           1002012-04-18 user02                                             0           1002012-04-18 user03                                             451         -3512012-04-19 user01                                             0           1002012-04-19 user02                                             0           1002012-04-19 user03                                             451         -3512012-04-20 user01                                             0           1002012-04-20 user02                                             0           1002012-04-20 user03                                             451         -3512012-04-21 user01                                             0           1002012-04-21 user02                                             0           1002012-04-21 user03                                             451         -3512012-04-22 user01                                             0           1002012-04-22 user02                                             0           1002012-04-22 user03                                             451         -3512012-04-23 user01                                             0           1002012-04-23 user02                                             0           1002012-04-23 user03                                             451         -3512012-04-24 user01                                             0           1002012-04-24 user02                                             0           1002012-04-24 user03                                             451         -3512012-04-25 user01                                             0           1002012-04-25 user02                                             0           1002012-04-25 user03                                             451         -3512012-04-26 user01                                             0           1002012-04-26 user02                                             0           1002012-04-26 user03                                             451         -3512012-04-27 user01                                             0           1002012-04-27 user02                                             0           1002012-04-27 user03                                             451         -3512012-04-28 user01                                             0           1002012-04-28 user02                                             0           1002012-04-28 user03                                             451         -3512012-04-29 user01                                             0           1002012-04-29 user02                                             0           1002012-04-29 user03                                             451         -3512012-04-30 user01                                             0           1002012-04-30 user02                                             0           1002012-04-30 user03                                             451         -3512012-05-01 user01                                             0           1002012-05-01 user02                                             0           1002012-05-01 user03                                             451         -3512012-05-02 user01                                             0           1002012-05-02 user02                                             0           1002012-05-02 user03                                             451         -3512012-05-03 user01                                             0           1002012-05-03 user02                                             0           1002012-05-03 user03                                             451         -3512012-05-04 user01                                             0           1002012-05-04 user02                                             0           1002012-05-04 user03                                             451         -3512012-05-05 user01                                             0           1002012-05-05 user02                                             0           1002012-05-05 user03                                             451         -3512012-05-06 user01                                             0           1002012-05-06 user02                                             0           1002012-05-06 user03                                             451         -3512012-05-07 user01                                             0           1002012-05-07 user02                                             0           1002012-05-07 user03                                             451         -3512012-05-08 user01                                             0           1002012-05-08 user02                                             0           1002012-05-08 user03                                             451         -3512012-05-09 user01                                             0           1002012-05-09 user02                                             0           1002012-05-09 user03                                             451         -3512012-05-10 user01                                             0           1002012-05-10 user02                                             0           1002012-05-10 user03                                             451         -3512012-05-11 user01                                             0           1002012-05-11 user02                                             0           1002012-05-11 user03                                             451         -3512012-05-12 user01                                             0           1002012-05-12 user02                                             0           1002012-05-12 user03                                             482         -3822012-05-13 user01                                             0           1002012-05-13 user02                                             0           1002012-05-13 user03                                             482         -3822012-05-14 user01                                             0           1002012-05-14 user02                                             0           1002012-05-14 user03                                             482         -3822012-05-15 user01                                             0           1002012-05-15 user02                                             0           1002012-05-15 user03                                             482         -3822012-05-16 user01                                             0           1002012-05-16 user02                                             0           1002012-05-16 user03                                             482         -3822012-05-17 user01                                             0           1002012-05-17 user02                                             0           1002012-05-17 user03                                             482         -3822012-05-18 user01                                             0           1002012-05-18 user02                                             0           1002012-05-18 user03                                             482         -3822012-05-19 user01                                             0           1002012-05-19 user02                                             0           1002012-05-19 user03                                             482         -3822012-05-20 user01                                             0           1002012-05-20 user02                                             0           1002012-05-20 user03                                             482         -3822012-05-21 user01                                             0           1002012-05-21 user02                                             0           1002012-05-21 user03                                             482         -3822012-05-22 user01                                             0           1002012-05-22 user02                                             0           1002012-05-22 user03                                             482         -3822012-05-23 user01                                             0           1002012-05-23 user02                                             0           1002012-05-23 user03                                             482         -3822012-05-24 user01                                             0           1002012-05-24 user02                                             0           1002012-05-24 user03                                             482         -3822012-05-25 user01                                             0           1002012-05-25 user02                                             0           1002012-05-25 user03                                             482         -3822012-05-26 user01                                             0           1002012-05-26 user02                                             0           1002012-05-26 user03                                             482         -3822012-05-27 user01                                             0           1002012-05-27 user02                                             0           1002012-05-27 user03                                             482         -3822012-05-28 user01                                             0           1002012-05-28 user02                                             0           1002012-05-28 user03                                             482         -3822012-05-29 user01                                             0           1002012-05-29 user02                                             0           1002012-05-29 user03                                             482         -3822012-05-30 user01                                             0           1002012-05-30 user02                                             0           1002012-05-30 user03                                             482         -3822012-05-31 user01                                             0           1002012-05-31 user02                                             0           1002012-05-31 user03                                             482         -3822012-06-01 user01                                             0           1002012-06-01 user02                                             0           1002012-06-01 user03                                             482         -3822012-06-02 user01                                             0           1002012-06-02 user02                                             0           1002012-06-02 user03                                             482         -3822012-06-03 user01                                             0           1002012-06-03 user02                                             0           1002012-06-03 user03                                             482         -3822012-06-04 user01                                             0           1002012-06-04 user02                                             0           1002012-06-04 user03                                             482         -3822012-06-05 user01                                             0           1002012-06-05 user02                                             0           1002012-06-05 user03                                             482         -3822012-06-06 user01                                             0           1002012-06-06 user02                                             0           1002012-06-06 user03                                             482         -3822012-06-07 user01                                             0           1002012-06-07 user02                                             0           1002012-06-07 user03                                             482         -3822012-06-08 user01                                             0           1002012-06-08 user02                                             0           1002012-06-08 user03                                             482         -3822012-06-09 user01                                             0           1002012-06-09 user02                                             0           1002012-06-09 user03                                             482         -3822012-06-10 user01                                             0           1002012-06-10 user02                                             0           1002012-06-10 user03                                             482         -3822012-06-11 user01                                             0           1002012-06-11 user02                                             0           1002012-06-11 user03                                             482         -3822012-06-12 user01                                             0           1002012-06-12 user02                                             0           1002012-06-12 user03                                             482         -3822012-06-13 user01                                             0           1002012-06-13 user02                                             0           1002012-06-13 user03                                             482         -3822012-06-14 user01                                             0           1002012-06-14 user02                                             0           1002012-06-14 user03                                             482         -3822012-06-15 user01                                             0           1002012-06-15 user02                                             0           1002012-06-15 user03                                             482         -3822012-06-16 user01                                             0           1002012-06-16 user02                                             0           1002012-06-16 user03                                             482         -3822012-06-17 user01                                             0           1002012-06-17 user02                                             0           1002012-06-17 user03                                             482         -3822012-06-18 user01                                             0           1002012-06-18 user02                                             0           1002012-06-18 user03                                             482         -3822012-06-19 user01                                             0           1002012-06-19 user02                                             0           1002012-06-19 user03                                             482         -3822012-06-20 user01                                             0           1002012-06-20 user02                                             0           1002012-06-20 user03                                             482         -3822012-06-21 user01                                             0           1002012-06-21 user02                                             0           1002012-06-21 user03                                             482         -3822012-06-22 user01                                             0           1002012-06-22 user02                                             0           1002012-06-22 user03                                             482         -3822012-06-23 user01                                             0           1002012-06-23 user02                                             0           1002012-06-23 user03                                             482         -3822012-06-24 user01                                             0           1002012-06-24 user02                                             0           1002012-06-24 user03                                             482         -3822012-06-25 user01                                             0           1002012-06-25 user02                                             0           1002012-06-25 user03                                             482         -3822012-06-26 user01                                             0           1002012-06-26 user02                                             0           1002012-06-26 user03                                             482         -3822012-06-27 user01                                             0           1002012-06-27 user02                                             0           1002012-06-27 user03                                             482         -3822012-06-28 user01                                             0           1002012-06-28 user02                                             0           1002012-06-28 user03                                             482         -3822012-06-29 user01                                             0           1002012-06-29 user02                                             0           1002012-06-29 user03                                             482         -3822012-06-30 user01                                             0           1002012-06-30 user02                                             0           1002012-06-30 user03                                             482         -3822012-07-01 user01                                             0           1002012-07-01 user02                                             0           1002012-07-01 user03                                             482         -3822012-07-02 user01                                             0           1002012-07-02 user02                                             0           1002012-07-02 user03                                             482         -3822012-07-03 user01                                             0           1002012-07-03 user02                                             0           1002012-07-03 user03                                             482         -3822012-07-04 user01                                             0           1002012-07-04 user02                                             0           1002012-07-04 user03                                             482         -3822012-07-05 user01                                             0           1002012-07-05 user02                                             0           1002012-07-05 user03                                             482         -3822012-07-06 user01                                             0           1002012-07-06 user02                                             0           1002012-07-06 user03                                             482         -3822012-07-07 user01                                             0           1002012-07-07 user02                                             0           1002012-07-07 user03                                             482         -3822012-07-08 user01                                             0           1002012-07-08 user02                                             0           1002012-07-08 user03                                             482         -3822012-07-09 user01                                             0           1002012-07-09 user02                                             0           1002012-07-09 user03                                             482         -3822012-07-10 user01                                             0           1002012-07-10 user02                                             0           1002012-07-10 user03                                             482         -3822012-07-11 user01                                             0           1002012-07-11 user02                                             0           1002012-07-11 user03                                             482         -3822012-07-12 user01                                             0           1002012-07-12 user02                                             0           1002012-07-12 user03                                             482         -3822012-07-13 user01                                             0           1002012-07-13 user02                                             0           1002012-07-13 user03                                             482         -3822012-07-14 user01                                             0           1002012-07-14 user02                                             0           1002012-07-14 user03                                             482         -3822012-07-15 user01                                             0           1002012-07-15 user02                                             0           1002012-07-15 user03                                             482         -3822012-07-16 user01                                             0           1002012-07-16 user02                                             0           1002012-07-16 user03                                             482         -3822012-07-17 user01                                             0           1002012-07-17 user02                                             0           1002012-07-17 user03                                             482         -3822012-07-18 user01                                             0           1002012-07-18 user02                                             0           1002012-07-18 user03                                             482         -3822012-07-19 user01                                             0           1002012-07-19 user02                                             0           1002012-07-19 user03                                             482         -3822012-07-20 user01                                             0           1002012-07-20 user02                                             0           1002012-07-20 user03                                             482         -3822012-07-21 user01                                             0           1002012-07-21 user02                                             0           1002012-07-21 user03                                             482         -3822012-07-22 user01                                             0           1002012-07-22 user02                                             0           1002012-07-22 user03                                             482         -3822012-07-23 user01                                             0           1002012-07-23 user02                                             0           1002012-07-23 user03                                             482         -3822012-07-24 user01                                             0           1002012-07-24 user02                                             0           1002012-07-24 user03                                             589         -4892012-07-25 user01                                             0           1002012-07-25 user02                                             0           1002012-07-25 user03                                             589         -4892012-07-26 user01                                             0           1002012-07-26 user02                                             0           1002012-07-26 user03                                             589         -4892012-07-27 user01                                             0           1002012-07-27 user02                                             0           1002012-07-27 user03                                             589         -4892012-07-28 user01                                             0           1002012-07-28 user02                                             0           1002012-07-28 user03                                             589         -4892012-07-29 user01                                             0           1002012-07-29 user02                                             0           1002012-07-29 user03                                             589         -4892012-07-30 user01                                             0           1002012-07-30 user02                                             0           1002012-07-30 user03                                             589         -4892012-07-31 user01                                             0           1002012-07-31 user02                                             0           1002012-07-31 user03                                             589         -4892012-08-01 user01                                             0           1002012-08-01 user02                                             0           1002012-08-01 user03                                             589         -4892012-08-02 user01                                             0           1002012-08-02 user02                                             0           1002012-08-02 user03                                             589         -4892012-08-03 user01                                             0           1002012-08-03 user02                                             0           1002012-08-03 user03                                             589         -4892012-08-04 user01                                             0           1002012-08-04 user02                                             0           1002012-08-04 user03                                             589         -4892012-08-05 user01                                             0           1002012-08-05 user02                                             0           1002012-08-05 user03                                             589         -4892012-08-06 user01                                             0           1002012-08-06 user02                                             0           1002012-08-06 user03                                             589         -4892012-08-07 user01                                             0           1002012-08-07 user02                                             0           1002012-08-07 user03                                             589         -4892012-08-08 user01                                             0           1002012-08-08 user02                                             0           1002012-08-08 user03                                             589         -4892012-08-09 user01                                             0           1002012-08-09 user02                                             0           1002012-08-09 user03                                             589         -4892012-08-10 user01                                             0           1002012-08-10 user02                                             0           1002012-08-10 user03                                             589         -4892012-08-11 user01                                             0           1002012-08-11 user02                                             0           1002012-08-11 user03                                             589         -4892012-08-12 user01                                             0           1002012-08-12 user02                                             0           1002012-08-12 user03                                             589         -4892012-08-13 user01                                             0           1002012-08-13 user02                                             0           1002012-08-13 user03                                             589         -4892012-08-14 user01                                             0           1002012-08-14 user02                                             0           1002012-08-14 user03                                             589         -4892012-08-15 user01                                             0           1002012-08-15 user02                                             0           1002012-08-15 user03                                             589         -4892012-08-16 user01                                             0           1002012-08-16 user02                                             0           1002012-08-16 user03                                             642         -5422012-08-17 user01                                             0           1002012-08-17 user02                                             0           1002012-08-17 user03                                             642         -5422012-08-18 user01                                             0           1002012-08-18 user02                                             0           1002012-08-18 user03                                             642         -5422012-08-19 user01                                             0           1002012-08-19 user02                                             0           1002012-08-19 user03                                             642         -5422012-08-20 user01                                             0           1002012-08-20 user02                                             0           1002012-08-20 user03                                             642         -5422012-08-21 user01                                             0           1002012-08-21 user02                                             0           1002012-08-21 user03                                             642         -5422012-08-22 user01                                             0           1002012-08-22 user02                                             0           1002012-08-22 user03                                             642         -5422012-08-23 user01                                             0           1002012-08-23 user02                                             0           1002012-08-23 user03                                             642         -5422012-08-24 user01                                             0           1002012-08-24 user02                                             0           1002012-08-24 user03                                             642         -5422012-08-25 user01                                             0           1002012-08-25 user02                                             0           1002012-08-25 user03                                             642         -5422012-08-26 user01                                             0           1002012-08-26 user02                                             0           1002012-08-26 user03                                             642         -5422012-08-27 user01                                             0           1002012-08-27 user02                                             0           1002012-08-27 user03                                             642         -5422012-08-28 user01                                             0           1002012-08-28 user02                                             0           1002012-08-28 user03                                             642         -5422012-08-29 user01                                             0           1002012-08-29 user02                                             0           1002012-08-29 user03                                             642         -5422012-08-30 user01                                             0           1002012-08-30 user02                                             0           1002012-08-30 user03                                             642         -5422012-08-31 user01                                             0           1002012-08-31 user02                                             0           1002012-08-31 user03                                             642         -5422012-09-01 user01                                             42          582012-09-01 user02                                             0           1002012-09-01 user03                                             642         -5422012-09-02 user01                                             68          322012-09-02 user02                                             23          772012-09-02 user03                                             642         -5422012-09-03 user01                                             68          322012-09-03 user02                                             23          772012-09-03 user03                                             642         -5422012-09-04 user01                                             186         -862012-09-04 user02                                             68          322012-09-04 user03                                             642         -5422012-09-05 user01                                             186         -862012-09-05 user02                                             68          322012-09-05 user03                                             642         -5422012-09-06 user01                                             186         -862012-09-06 user02                                             68          322012-09-06 user03                                             642         -5422012-09-07 user01                                             278         -1782012-09-07 user02                                             186         -862012-09-07 user03                                             665         -5652012-09-08 user01                                             278         -1782012-09-08 user02                                             186         -862012-09-08 user03                                             665         -5652012-09-09 user01                                             308         -2082012-09-09 user02                                             186         -862012-09-09 user03                                             665         -5652012-09-10 user01                                             308         -2082012-09-10 user02                                             278         -1782012-09-10 user03                                             665         -5652012-09-11 user01                                             308         -2082012-09-11 user02                                             278         -1782012-09-11 user03                                             665         -5652012-09-12 user01                                             308         -2082012-09-12 user02                                             278         -1782012-09-12 user03                                             665         -5652012-09-13 user01                                             308         -2082012-09-13 user02                                             278         -1782012-09-13 user03                                             665         -5652012-09-14 user01                                             308         -2082012-09-14 user02                                             278         -1782012-09-14 user03                                             665         -5652012-09-15 user01                                             308         -2082012-09-15 user02                                             278         -1782012-09-15 user03                                             665         -5652012-09-16 user01                                             308         -2082012-09-16 user02                                             278         -1782012-09-16 user03                                             665         -5652012-09-17 user01                                             308         -2082012-09-17 user02                                             278         -1782012-09-17 user03                                             665         -5652012-09-18 user01                                             308         -2082012-09-18 user02                                             278         -1782012-09-18 user03                                             665         -5652012-09-19 user01                                             308         -2082012-09-19 user02                                             278         -1782012-09-19 user03                                             665         -5652012-09-20 user01                                             308         -2082012-09-20 user02                                             278         -1782012-09-20 user03                                             665         -5652012-09-21 user01                                             308         -2082012-09-21 user02                                             278         -1782012-09-21 user03                                             665         -5652012-09-22 user01                                             308         -2082012-09-22 user02                                             278         -1782012-09-22 user03                                             665         -5652012-09-23 user01                                             308         -2082012-09-23 user02                                             278         -1782012-09-23 user03                                             665         -5652012-09-24 user01                                             308         -2082012-09-24 user02                                             278         -1782012-09-24 user03                                             665         -5652012-09-25 user01                                             308         -2082012-09-25 user02                                             278         -1782012-09-25 user03                                             665         -5652012-09-26 user01                                             308         -2082012-09-26 user02                                             278         -1782012-09-26 user03                                             665         -5652012-09-27 user01                                             308         -2082012-09-27 user02                                             278         -1782012-09-27 user03                                             665         -5652012-09-28 user01                                             308         -2082012-09-28 user02                                             278         -1782012-09-28 user03                                             665         -5652012-09-29 user01                                             308         -2082012-09-29 user02                                             278         -1782012-09-29 user03                                             665         -5652012-09-30 user01                                             308         -2082012-09-30 user02                                             278         -1782012-09-30 user03                                             673         -5732012-10-01 user01                                             308         -2082012-10-01 user02                                             278         -1782012-10-01 user03                                             673         -5732012-10-02 user01                                             308         -2082012-10-02 user02                                             278         -1782012-10-02 user03                                             673         -5732012-10-03 user01                                             308         -2082012-10-03 user02                                             278         -1782012-10-03 user03                                             673         -5732012-10-04 user01                                             308         -2082012-10-04 user02                                             278         -1782012-10-04 user03                                             673         -5732012-10-05 user01                                             308         -2082012-10-05 user02                                             278         -1782012-10-05 user03                                             673         -5732012-10-06 user01                                             308         -2082012-10-06 user02                                             278         -1782012-10-06 user03                                             673         -5732012-10-07 user01                                             308         -2082012-10-07 user02                                             278         -1782012-10-07 user03                                             673         -5732012-10-08 user01                                             308         -2082012-10-08 user02                                             278         -1782012-10-08 user03                                             673         -5732012-10-09 user01                                             308         -2082012-10-09 user02                                             278         -1782012-10-09 user03                                             673         -5732012-10-10 user01                                             308         -2082012-10-10 user02                                             278         -1782012-10-10 user03                                             673         -5732012-10-11 user01                                             308         -2082012-10-11 user02                                             278         -1782012-10-11 user03                                             694         -5942012-10-12 user01                                             308         -2082012-10-12 user02                                             278         -1782012-10-12 user03                                             694         -5942012-10-13 user01                                             308         -2082012-10-13 user02                                             278         -1782012-10-13 user03                                             694         -5942012-10-14 user01                                             308         -2082012-10-14 user02                                             278         -1782012-10-14 user03                                             694         -5942012-10-15 user01                                             308         -2082012-10-15 user02                                             278         -1782012-10-15 user03                                             694         -5942012-10-16 user01                                             308         -2082012-10-16 user02                                             278         -1782012-10-16 user03                                             694         -5942012-10-17 user01                                             308         -2082012-10-17 user02                                             278         -1782012-10-17 user03                                             694         -5942012-10-18 user01                                             308         -2082012-10-18 user02                                             278         -1782012-10-18 user03                                             694         -5942012-10-19 user01                                             308         -2082012-10-19 user02                                             278         -1782012-10-19 user03                                             694         -5942012-10-20 user01                                             308         -2082012-10-20 user02                                             278         -1782012-10-20 user03                                             694         -5942012-10-21 user01                                             308         -2082012-10-21 user02                                             278         -1782012-10-21 user03                                             694         -5942012-10-22 user01                                             308         -2082012-10-22 user02                                             278         -1782012-10-22 user03                                             694         -5942012-10-23 user01                                             308         -2082012-10-23 user02                                             278         -1782012-10-23 user03                                             694         -5942012-10-24 user01                                             308         -2082012-10-24 user02                                             278         -1782012-10-24 user03                                             694         -5942012-10-25 user01                                             308         -2082012-10-25 user02                                             278         -1782012-10-25 user03                                             694         -5942012-10-26 user01                                             308         -2082012-10-26 user02                                             278         -1782012-10-26 user03                                             694         -5942012-10-27 user01                                             308         -2082012-10-27 user02                                             278         -1782012-10-27 user03                                             694         -5942012-10-28 user01                                             308         -2082012-10-28 user02                                             278         -1782012-10-28 user03                                             694         -5942012-10-29 user01                                             308         -2082012-10-29 user02                                             278         -1782012-10-29 user03                                             694         -5942012-10-30 user01                                             308         -2082012-10-30 user02                                             278         -1782012-10-30 user03                                             694         -5942012-10-31 user01                                             308         -2082012-10-31 user02                                             278         -1782012-10-31 user03                                             694         -5942012-11-01 user01                                             308         -2082012-11-01 user02                                             278         -1782012-11-01 user03                                             694         -5942012-11-02 user01                                             308         -2082012-11-02 user02                                             278         -1782012-11-02 user03                                             694         -5942012-11-03 user01                                             308         -2082012-11-03 user02                                             278         -1782012-11-03 user03                                             694         -5942012-11-04 user01                                             308         -2082012-11-04 user02                                             278         -1782012-11-04 user03                                             694         -5942012-11-05 user01                                             308         -2082012-11-05 user02                                             278         -1782012-11-05 user03                                             694         -5942012-11-06 user01                                             308         -2082012-11-06 user02                                             278         -1782012-11-06 user03                                             694         -5942012-11-07 user01                                             308         -2082012-11-07 user02                                             278         -1782012-11-07 user03                                             694         -5942012-11-08 user01                                             308         -2082012-11-08 user02                                             278         -1782012-11-08 user03                                             694         -5942012-11-09 user01                                             308         -2082012-11-09 user02                                             278         -1782012-11-09 user03                                             694         -5942012-11-10 user01                                             308         -2082012-11-10 user02                                             278         -1782012-11-10 user03                                             694         -5942012-11-11 user01                                             308         -2082012-11-11 user02                                             278         -1782012-11-11 user03                                             694         -5942012-11-12 user01                                             308         -2082012-11-12 user02                                             278         -1782012-11-12 user03                                             694         -5942012-11-13 user01                                             308         -2082012-11-13 user02                                             278         -1782012-11-13 user03                                             694         -5942012-11-14 user01                                             308         -2082012-11-14 user02                                             278         -1782012-11-14 user03                                             694         -5942012-11-15 user01                                             308         -2082012-11-15 user02                                             278         -1782012-11-15 user03                                             694         -5942012-11-16 user01                                             308         -2082012-11-16 user02                                             278         -1782012-11-16 user03                                             694         -5942012-11-17 user01                                             308         -2082012-11-17 user02                                             278         -1782012-11-17 user03                                             694         -5942012-11-18 user01                                             308         -2082012-11-18 user02                                             278         -1782012-11-18 user03                                             694         -5942012-11-19 user01                                             308         -2082012-11-19 user02                                             278         -1782012-11-19 user03                                             694         -5942012-11-20 user01                                             308         -2082012-11-20 user02                                             278         -1782012-11-20 user03                                             694         -5942012-11-21 user01                                             308         -2082012-11-21 user02                                             278         -1782012-11-21 user03                                             778         -678(975 行受影响) */           

   *作者：Stephenzhou(阿蒙)     
 *日期: 2012.08.30      
 *Mail:[email protected]     
 *另外：转载请著名出处。
 *博客地址：http://blog.csdn.net/szstephenzhou