将结果集插入另一个表中
将结果集插入另一个表中 insert into rep_agentworksum (DateTime,AgentName ,DayWorkSum , DayWork ) SELECT DateTime,AgentName ,Count(SessionId)as DayWorkSum ,1 as DayWork FROM cti_record WHERE Date ='2012-03-04' and AgentName in (1006,1013 ) group by AgentName