v_ping_ejj int, –PING码上行其中EJJ用户数
@v_ping_bjj int, –PING码上行其中BJJ用户数
@v_ping_con int, –PING码上行中注册和未注册的用户...(char(10), registertime,20) =CONVERT(char(10), dateadd(dd,-1,getdate()),20)
union all...CONVERT(char(10), dateadd(dd,-1,getdate()),20)) a
–统计ping码上行数据tb_gl_userreplycommand
–...(char(10), sendtime,20) =CONVERT(char(10), dateadd(dd,-1,getdate()),20)) a
–发送ping码且发送EJJ用户数...(char(10), sendtime,20) =CONVERT(char(10), dateadd(dd,-1,getdate()),20)) a
where telephone