Demo entry 6718973

11

   

Submitted by lilei on Mar 07, 2018 at 14:48
Language: SQL. Code size: 382 Bytes.

select distinct r_hall_type, r_hall_name, r_emp_dept
  from V_TE_R_ORDER_ITEM_STAT_DAY
 where  r_hall_type not in ('业务支撑中心:', '其它:', ':')
   and r_emp_name != '乌市批量操作工号'
   and r_hall_name not in ('新疆电信有限公司业务支撑中心',
                           '电子渠道项目组/增值与号百办',
                           '乌鲁木齐市分公司号码百事通运营中心')
   and r_prom_emp != 'Siebel') and r_order_item_action_cd = '新装'

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).