日期:2014-05-17 浏览次数:20461 次
create table #t_case_assign_log( ID int identity, 案件ID int, 分配日期 datetime, 分配人ID int, 闭合日期 datetime, 闭合人ID int,是否闭合 bit )
go
insert into #t_case_assign_log
select 8,'2010-4-2',10,'1900-1-1',0,0 union all
select 8,'2010-5-2',12,'1900-1-1',0,0 union all
select 8,'2010-7-12',10,'1900-1-1',0,0 union all
select 9,'2010-4-2',10,'1900-1-1',0,0 union all
select 9,'2010-4-2',12,'1900-1-1',0,0 union all
select 10,'2010-4-2',10,'2010-5-4',0,0 union all
select 8,'2010-8-2',10,'2010-8-4',14,1 union all
select 8,'2010-8-4',14,'2010-9-1',12,1 union all
select 9,'2010-8-4',10,'2010-8-9',8,1 union all
select 10,'2010-8-5',10,'2010-9-4',8,1 union all
select 8,'2010-9-1',12,'1900-1-1',0,0 union all
select 9,'2010-8-9',8,'1900-1-1',0,0 union all
select 10,'2010-9-4',8,'1900-1-1',0,0
go
select *from #t_case_assign_log