SQL语句精减
语句精减，语句如下：
update kq_result set G_qkcs=(select count(*) from kq_result G,Kq_SourceQk k where k.qktype= '深圳人 ' and G.empid=k.empid and G.fdate=DATEADD(day,DATEDIFF(day,0,(k.fdatetime)),0)) from kq_result g,Kq_SourceQk k where k.qktype= '深圳人 ' and g.empid=k.empid and g.fdate=DATEADD(day,DATEDIFF(day,0,(k.fdatetime)),0)
共计304个字符,因特殊需要需将语句字符数量控制在249个字符以下。请大伙帮忙~~
[解决办法]
update G set G_qkcs=k.cn from kq_result G,(Select empid,fdatetime,count(*) cn from Kq_SourceQk where qktype= '深圳人 ' group by empid,fdatetime) k where G.empid=k.empid and Datediff(day,g.fdate,k.fdatetime)=0
