求助，来一SQL解决下

lounddong 2009-11-12 05:48:27 


--考勤表fty_grkq,我只列了部分数据，如下（type:W 为正常上班，F为法定假期，J为请假，H为半天请假，X为休息）

--请假记录表fty_leave

--问题：根据请假记录表更新考勤表的数据，要考虑多个员工的情况，每个员工每月请假记录可能有多条

--结果应该如下：

/*

D6686 2009-05-01 F NULL	NULL NULL NULL

D6686 2009-05-02 X NULL NULL NULL NULL

D6686 2009-05-03 X NULL NULL NULL NULL

D6686 2009-05-04 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-05 X NULL NULL NULL NULL

D6686 2009-05-06 X NULL NULL NULL NULL

D6686 2009-05-07 X NULL NULL NULL NULL

D6686 2009-05-08 X NULL NULL NULL NULL

D6686 2009-05-09 X NULL NULL NULL NULL

D6686 2009-05-10 X NULL NULL NULL NULL

D6686 2009-05-11 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-12 X NULL NULL NULL NULL

D6686 2009-05-13 X NULL NULL NULL NULL

D6686 2009-05-14 X NULL NULL NULL NULL

D6686 2009-05-15 H 08:00:24 12:03:31NULL NULL

D6686 2009-05-16 X NULL NULL NULL NULL

D6686 2009-05-17 X NULL NULL NULL NULL

D6686 2009-05-18 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-19 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-20 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-21 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-22 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-23 X NULL NULL NULL NULL

D6686 2009-05-24 X NULL NULL NULL NULL

D6686 2009-05-25 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-26 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-27 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-28 F NULL NULL NULL NULL

D6686 2009-05-29 W 08:00:24 12:03:31 13:52:20 18:01:36

D6686 2009-05-30 X NULL NULL NULL NULL

D6686 2009-05-31 X NULL NULL NULL NULL

D3686 2009-05-01 F NULL	NULL NULL NULL

D3686 2009-05-02 X NULL NULL NULL NULL

D3686 2009-05-03 X NULL NULL NULL NULL

D3686 2009-05-04 W 08:00:24 12:03:31 13:52:20 18:01:36

D3686 2009-05-05 W 08:00:24 12:03:31 13:52:20 18:01:36

D3686 2009-05-06 X NULL NULL NULL NULL

D3686 2009-05-07 X NULL NULL NULL NULL

D3686 2009-05-08 H 08:00:24 12:03:31 NULL NULL

D3686 2009-05-09 X NULL NULL NULL NULL

D3686 2009-05-10 X NULL NULL NULL NULL

*/

--> 测试数据：fty_grkq

if object_id('fty_grkq') is not null

drop table fty_grkq

create table fty_grkq ([mem_id] varchar(5),[adate] varchar(10),[type] varchar(1),

[a1] varchar(8),[a2] varchar(8),[a3] varchar(8),[a4] varchar(8))

insert into fty_grkq

select 'D6686','2009-05-01','F',null,null,null,null union all

select 'D6686','2009-05-02','X',null,null,null,null union all

select 'D6686','2009-05-03','X',null,null,null,null union all

select 'D6686','2009-05-04','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-05','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-06','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-07','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-08','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-09','X',null,null,null,null union all

select 'D6686','2009-05-10','X',null,null,null,null union all

select 'D6686','2009-05-11','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-12','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-13','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-14','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-15','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-16','X',null,null,null,null union all

select 'D6686','2009-05-17','X',null,null,null,null union all

select 'D6686','2009-05-18','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-19','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-20','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-21','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-22','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-23','X',null,null,null,null union all

select 'D6686','2009-05-24','X',null,null,null,null union all

select 'D6686','2009-05-25','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-26','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-27','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-28','F',null,null,null,null union all

select 'D6686','2009-05-29','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-30','X',null,null,null,null union all

select 'D6686','2009-05-31','X',null,null,null,null union all

select 'D3686','2009-05-01','F',null,null,null,null union all

select 'D3686','2009-05-02','X',null,null,null,null union all

select 'D3686','2009-05-03','X',null,null,null,null union all

select 'D3686','2009-05-04','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-05','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-06','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-07','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-08','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-09','X',null,null,null,null union all

select 'D3686','2009-05-10','X',null,null,null,null 



--> 测试数据：fty_leave

if object_id('fty_leave') is not null

drop table fty_leave

create table fty_leave([mem_id,adate,nums] varchar(5),[C2] varchar(10),[C3] numeric(2,1))

insert into fty_leave

select 'D6686','2009-05-05',5 union all

select 'D6686','2009-05-12',3.5 union all

select 'D3686','2009-05-06',2.5
...全文
142 14 打赏 收藏 转发到动态 举报
写回复
用AI写文章
14 条回复
切换为时间正序
请发表友善的回复…
发表回复
pbsh 2009-11-13
  • 打赏
  • 举报
 回复
又長又紅，看著暈。。
daiyueqiang2045 2009-11-12
  • 打赏
  • 举报
 回复
--author:diyueqiang
--date:2009-11-12
--创建Insert触发器 当请假时在fty_grkq表中插入数据。
--默认整体的为'mem_id',时间,'J',null,null,null,null.
--半天为'mem_id',时间,'H',null,null,null,null .当员工来时在修改这个考勤表的记录。
alter trigger tri_insert_fty_grkq
on fty_leave
for insert
as
declare @mem_id varchar(5)
declare @adate varchar(10)
declare @num float
declare @date datetime --开始请假时间
declare @fullday int --整天数量
declare @hday float--半天，主要是判断是否存在半天

select @mem_id=mem_id,@adate=adate,@num=nums
from inserted

set @fullday=@num;
set @hday=convert(int,@num*10)%10;--0则没有，否则就有
set @date=convert(datetime,@adate)

while @fullday>0
begin
INSERT INTO [dbo].[fty_grkq]([mem_id], [adate], [type], [a1], [a2], [a3], [a4])
VALUES (@mem_id,@adate,'J',null,null,null,null)
set @date=dateadd(day,1,@date) --天数加一
set @adate=convert(char(4),DATEPART(yy,@date)) +'-'+convert(char(2),DATEPART(mm ,@date))+'-'+convert(char(2),DATEPART(d,@date))
set @fullday=@fullday-1;
end
--判断是否存在半天
if @hday <>0
begin
insert fty_grkq values(@mem_id,@adate,'H',null,null,null,null)
end

你瞧瞧是这个效果不
luoyoumou 2009-11-12
  • 打赏
  • 举报
 回复
[Quote=引用 9 楼 bancxc 的回复:]
不运动不行
[/Quote]

--吃饱了撑着
--小F-- 2009-11-12
  • 打赏
  • 举报
 回复
很长
feixianxxx 2009-11-12
  • 打赏
  • 举报
 回复
[Quote=引用 9 楼 bancxc 的回复:]
不运动不行
[/Quote]
写SQL语句 就是运动~
bancxc 2009-11-12
  • 打赏
  • 举报
 回复
不运动不行
feixianxxx 2009-11-12
  • 打赏
  • 举报
 回复
[Quote=引用 7 楼 bancxc 的回复:]
帮顶 没看明白
[/Quote]
你的头像 跑得累么？
bancxc 2009-11-12
  • 打赏
  • 举报
 回复
帮顶 没看明白
feixianxxx 2009-11-12
  • 打赏
  • 举报
 回复
修改下 



update fty_grkq

set [type]=k.[type],

[a1]=case when k.[type]='H' then [a1] end ,

[a2]=case when k.[type]='H' then [a2] end ,

[a3]=null,

[a4]=null 

from fty_grkq join (

select [mem_id,adate,nums],dat,[type]=case when cast( C2 as datetime)+floor(C3)=dat then 'H' else 'X' end 

from (

select [mem_id,adate,nums] ,cast( C2 as datetime)+number as dat,C3,C2 

from fty_leave a , master..spt_values 

where CEILING(C3)>number and type='p') z ) k 

on fty_grkq.[mem_id]=k.[mem_id,adate,nums] and dat=fty_grkq.adate



select * from fty_grkq

/*

mem_id adate      type a1       a2       a3       a4

------ ---------- ---- -------- -------- -------- --------

D6686  2009-05-01 F    NULL     NULL     NULL     NULL

D6686  2009-05-02 X    NULL     NULL     NULL     NULL

D6686  2009-05-03 X    NULL     NULL     NULL     NULL

D6686  2009-05-04 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-05 X    NULL     NULL     NULL     NULL

D6686  2009-05-06 X    NULL     NULL     NULL     NULL

D6686  2009-05-07 X    NULL     NULL     NULL     NULL

D6686  2009-05-08 X    NULL     NULL     NULL     NULL

D6686  2009-05-09 X    NULL     NULL     NULL     NULL

D6686  2009-05-10 X    NULL     NULL     NULL     NULL

D6686  2009-05-11 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-12 X    NULL     NULL     NULL     NULL

D6686  2009-05-13 X    NULL     NULL     NULL     NULL

D6686  2009-05-14 X    NULL     NULL     NULL     NULL

D6686  2009-05-15 H    08:00:24 12:03:31 NULL     NULL

D6686  2009-05-16 X    NULL     NULL     NULL     NULL

D6686  2009-05-17 X    NULL     NULL     NULL     NULL

D6686  2009-05-18 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-19 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-20 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-21 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-22 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-23 X    NULL     NULL     NULL     NULL

D6686  2009-05-24 X    NULL     NULL     NULL     NULL

D6686  2009-05-25 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-26 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-27 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-28 F    NULL     NULL     NULL     NULL

D6686  2009-05-29 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-30 X    NULL     NULL     NULL     NULL

D6686  2009-05-31 X    NULL     NULL     NULL     NULL

D3686  2009-05-01 F    NULL     NULL     NULL     NULL

D3686  2009-05-02 X    NULL     NULL     NULL     NULL

D3686  2009-05-03 X    NULL     NULL     NULL     NULL

D3686  2009-05-04 W    08:00:24 12:03:31 13:52:20 18:01:36

D3686  2009-05-05 W    08:00:24 12:03:31 13:52:20 18:01:36

D3686  2009-05-06 X    NULL     NULL     NULL     NULL

D3686  2009-05-07 X    NULL     NULL     NULL     NULL

D3686  2009-05-08 H    08:00:24 12:03:31 NULL     NULL

D3686  2009-05-09 X    NULL     NULL     NULL     NULL

D3686  2009-05-10 X    NULL     NULL     NULL     NULL



*/
feixianxxx 2009-11-12
  • 打赏
  • 举报
 回复 
update fty_grkq

set [type]=k.[type],

[a1]=case when k.[type]='H' then [a1] end ,

[a2]=case when k.[type]='H' then [a2] end ,

[a3]=case when k.[type]='H' then [a3] end 

from fty_grkq join (

select [mem_id,adate,nums],dat,[type]=case when cast( C2 as datetime)+floor(C3)=dat then 'H' else 'X' end 

from (

select [mem_id,adate,nums] ,cast( C2 as datetime)+number as dat,C3,C2 

from fty_leave a , master..spt_values 

where CEILING(C3)>number and type='p') z ) k 

on fty_grkq.[mem_id]=k.[mem_id,adate,nums] and dat=fty_grkq.adate



select * from fty_grkq

/*

mem_id adate      type a1       a2       a3       a4

------ ---------- ---- -------- -------- -------- --------

D6686  2009-05-01 F    NULL     NULL     NULL     NULL

D6686  2009-05-02 X    NULL     NULL     NULL     NULL

D6686  2009-05-03 X    NULL     NULL     NULL     NULL

D6686  2009-05-04 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-05 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-06 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-07 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-08 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-09 X    NULL     NULL     NULL     NULL

D6686  2009-05-10 X    NULL     NULL     NULL     NULL

D6686  2009-05-11 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-12 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-13 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-14 X    NULL     NULL     NULL     18:01:36

D6686  2009-05-15 H    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-16 X    NULL     NULL     NULL     NULL

D6686  2009-05-17 X    NULL     NULL     NULL     NULL

D6686  2009-05-18 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-19 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-20 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-21 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-22 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-23 X    NULL     NULL     NULL     NULL

D6686  2009-05-24 X    NULL     NULL     NULL     NULL

D6686  2009-05-25 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-26 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-27 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-28 F    NULL     NULL     NULL     NULL

D6686  2009-05-29 W    08:00:24 12:03:31 13:52:20 18:01:36

D6686  2009-05-30 X    NULL     NULL     NULL     NULL

D6686  2009-05-31 X    NULL     NULL     NULL     NULL

D3686  2009-05-01 F    NULL     NULL     NULL     NULL

D3686  2009-05-02 X    NULL     NULL     NULL     NULL

D3686  2009-05-03 X    NULL     NULL     NULL     NULL

D3686  2009-05-04 W    08:00:24 12:03:31 13:52:20 18:01:36

D3686  2009-05-05 W    08:00:24 12:03:31 13:52:20 18:01:36

D3686  2009-05-06 X    NULL     NULL     NULL     18:01:36

D3686  2009-05-07 X    NULL     NULL     NULL     18:01:36

D3686  2009-05-08 H    08:00:24 12:03:31 13:52:20 18:01:36

D3686  2009-05-09 X    NULL     NULL     NULL     NULL

D3686  2009-05-10 X    NULL     NULL     NULL     NULL



(41 行受影响)



*/
nianran520 2009-11-12
  • 打赏
  • 举报
 回复 


KEN WONG

--> 测试数据：fty_grkq

if object_id('fty_grkq') is not null

drop table fty_grkq

create table fty_grkq ([mem_id] varchar(5),[adate] varchar(10),[type] varchar(1),

[a1] varchar(8),[a2] varchar(8),[a3] varchar(8),[a4] varchar(8))

insert into fty_grkq

select 'D6686','2009-05-01','F',null,null,null,null union all

select 'D6686','2009-05-02','X',null,null,null,null union all

select 'D6686','2009-05-03','X',null,null,null,null union all

select 'D6686','2009-05-04','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-05','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-06','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-07','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-08','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-09','X',null,null,null,null union all

select 'D6686','2009-05-10','X',null,null,null,null union all

select 'D6686','2009-05-11','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-12','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-13','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-14','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-15','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-16','X',null,null,null,null union all

select 'D6686','2009-05-17','X',null,null,null,null union all

select 'D6686','2009-05-18','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-19','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-20','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-21','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-22','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-23','X',null,null,null,null union all

select 'D6686','2009-05-24','X',null,null,null,null union all

select 'D6686','2009-05-25','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-26','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-27','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-28','F',null,null,null,null union all

select 'D6686','2009-05-29','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D6686','2009-05-30','X',null,null,null,null union all

select 'D6686','2009-05-31','X',null,null,null,null union all

select 'D3686','2009-05-01','F',null,null,null,null union all

select 'D3686','2009-05-02','X',null,null,null,null union all

select 'D3686','2009-05-03','X',null,null,null,null union all

select 'D3686','2009-05-04','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-05','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-06','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-07','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-08','W','08:00:24','12:03:31','13:52:20','18:01:36' union all

select 'D3686','2009-05-09','X',null,null,null,null union all

select 'D3686','2009-05-10','X',null,null,null,null 



--> 测试数据：fty_leave

if object_id('fty_leave') is not null

drop table fty_leave

create table fty_leave([mem_id] varchar(5),[adate] varchar(10),[nums] numeric(2,1))

insert into fty_leave

select 'D6686','2009-05-05',5 union all

select 'D6686','2009-05-12',3.5 union all

select 'D3686','2009-05-06',2.5 





--执行

update fty_grkq set 

type = case t.type when 'W' then case r.nums when 0 then 'J' else 'H' end  else t.type end,

a1= case t.type when 'W' then case r.nums when 0 then null else t.a1 end else t.a1 end,

a2= case t.type when 'W' then case r.nums when 0 then null else t.a1 end else t.a2 end,

a3= case t.type when 'W' then null else t.a3 end,

a4= case t.type when 'W' then null else t.a4 end

from fty_grkq as t,(select b.mem_id,b.adate,

case b.adate when convert(varchar(10),dateadd(day,ceiling(a.nums)-1,a.adate),120) then ceiling(nums) - nums else 0 end as nums

from fty_leave a ,fty_grkq b

where left(a.adate,7) = left(b.adate,7)

and a.mem_id = b.mem_id

and left(a.adate,7) = '2009-05'

and b.adate <= convert(varchar(10),dateadd(day,ceiling(a.nums) - 1,a.adate),120)

and b.adate >= a.adate) r

where t.adate = r.adate and t.mem_id = r.mem_id

--结果

select * from fty_grkq

------------------------------------------

D6686	2009-05-01	F	NULL	NULL	NULL	NULL

D6686	2009-05-02	X	NULL	NULL	NULL	NULL

D6686	2009-05-03	X	NULL	NULL	NULL	NULL

D6686	2009-05-04	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-05	J	NULL	NULL	NULL	NULL

D6686	2009-05-06	J	NULL	NULL	NULL	NULL

D6686	2009-05-07	J	NULL	NULL	NULL	NULL

D6686	2009-05-08	J	NULL	NULL	NULL	NULL

D6686	2009-05-09	X	NULL	NULL	NULL	NULL

D6686	2009-05-10	X	NULL	NULL	NULL	NULL

D6686	2009-05-11	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-12	J	NULL	NULL	NULL	NULL

D6686	2009-05-13	J	NULL	NULL	NULL	NULL

D6686	2009-05-14	J	NULL	NULL	NULL	NULL

D6686	2009-05-15	H	08:00:24	08:00:24	NULL	NULL

D6686	2009-05-16	X	NULL	NULL	NULL	NULL

D6686	2009-05-17	X	NULL	NULL	NULL	NULL

D6686	2009-05-18	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-19	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-20	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-21	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-22	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-23	X	NULL	NULL	NULL	NULL

D6686	2009-05-24	X	NULL	NULL	NULL	NULL

D6686	2009-05-25	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-26	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-27	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-28	F	NULL	NULL	NULL	NULL

D6686	2009-05-29	W	08:00:24	12:03:31	13:52:20	18:01:36

D6686	2009-05-30	X	NULL	NULL	NULL	NULL

D6686	2009-05-31	X	NULL	NULL	NULL	NULL

D3686	2009-05-01	F	NULL	NULL	NULL	NULL

D3686	2009-05-02	X	NULL	NULL	NULL	NULL

D3686	2009-05-03	X	NULL	NULL	NULL	NULL

D3686	2009-05-04	W	08:00:24	12:03:31	13:52:20	18:01:36

D3686	2009-05-05	W	08:00:24	12:03:31	13:52:20	18:01:36

D3686	2009-05-06	J	NULL	NULL	NULL	NULL

D3686	2009-05-07	J	NULL	NULL	NULL	NULL

D3686	2009-05-08	H	08:00:24	08:00:24	NULL	NULL

D3686	2009-05-09	X	NULL	NULL	NULL	NULL

D3686	2009-05-10	X	NULL	NULL	NULL	NULL
laker_914 2009-11-12
  • 打赏
  • 举报
 回复
没看明白，帮你顶一下
mjf_2008 2009-11-12
  • 打赏
  • 举报
 回复
沙发。。。。。
SQL77 2009-11-12
  • 打赏
  • 举报
 回复
帮顶
sql server 2008安装过程中服务器配置出错解决办法
sql server 2008安装过程中服务器配置出错，求助！！！！！！！ 解决方法： 当sql2008安装导向运行到这里时： 请选择：对所有SQL Server 服务使用相同的账号： 但这里不能给他设置自己定义的账号和密码(例如下面...
Sqlserver 2005附加数据库时出错提示操作系统错误5(拒绝访问)错误5120的解决办法
本人也遇到类似的问题，但是解决方法很简单，只需要使用管理员的身份打开SQL Server Management Studio，即可附加数据库了 如下图：  ，一时无解，遂求助于百度谷歌，经过各种试验，特将解决办法整理于此，希望能...
解析一个通过添加本地分区索引提高SQL性能的案例
今天接到同事求助，说有一个select query，在Oracle上要跑一分多钟，他希望能在5s内出结果，以下就是解决这个问题的方法，需要的朋友可以参考下
二十三种设计模式【PDF版】
有经验的面向对象设计者会告诉你，要一下子就得到复用性和灵活性好的设计， 即使不是不可能的至少也是非常困难的。一个设计在最终完成之前常要被复用好几次，而且每一次都有所修改。 有经验的面向对象设计者的确能...
sql常见问题解决
sql语句中返回时间格式（为了方便java代码中不用处理时间） DATE_FORMAT(字段名, ‘%Y-%m-%d %H:%i:%s’) AS 别名, %M 月名字(January……December) %W 星期名字(Sunday……Saturday) %D 有英语前缀的月份的日期...
应用实例

27,579

社区成员

68,558

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 应用实例
社区管理员
  • 应用实例社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章