27,579
社区成员
发帖
与我相关
我的任务
分享
select distinct indent_name,calltel_mask,indent_level1+indent_address,memo,'',
money_total,convert(varchar(10),indent_date,120),goods_detail,
case when goods_detail like'%礼品 Z%' then'NXB01' when goods_detail like'%礼品 L%' then'NXA01'when goods_detail like'%礼品 Y%' then'NXA01'when goods_detail like'%礼品 MK%' then'NXA01' end,c.emp_group
from t_indent a
join t_doindent b on a.indent_id = b.indent_id
join t_employee_inf c on a.ask_id=c.emp_id
Where datediff(year,[indent_date],getdate())=0
select distinct indent_name,calltel_mask,indent_level1+indent_address,a.memo,'',
money_total,convert(varchar(10),indent_date,120),goods_detail,
case when goods_detail like'%礼品 Z%' then'NXB01' when goods_detail like'%礼品 L%' then'NXA01'when goods_detail like'%礼品 Y%' then'NXA01'when goods_detail like'%礼品 MK%' then'NXA01' end,c.emp_group
from t_indent a
join t_doindent b on a.indent_id = b.indent_id
join t_employee_inf c on a.ask_id=c.emp_id
Where datediff(year,[indent_date],getdate())=0