27,579
社区成员
发帖
与我相关
我的任务
分享
insert into lanEmail(EmailTitle,timestr,EmailContent,FromUser,ToUser) select '工作提醒' ,getdate(),contentstr,'系统消息', ToUser from Tasklist where abs(datediff(hh,getdate(),timestr))<2 ;
insert into MailSjlList(id,sjr)
select max(a.mun) as id,a.ToUser from(
select row_number()over(partition by ToUser order by getdate()) as mun,
ToUser from Tasklist) a group by a.ToUser