62,041
社区成员
发帖
与我相关
我的任务
分享
taskListSql = "select *,'OBTaskResult'=case when OBTask_int_ResultID=1 then '暂时无法接通' when OBTask_int_ResultID=2 then '接通' when OBTask_int_ResultID=3 then '号码有误' when OBTask_int_ResultID=4 then '用户挂机' when OBTask_int_ResultID=5 then '稍后联系' end,'OBTaskStatus'= case when OBTask_int_StatusID=1 then '处理中' else '完成核实' end from (select b.* from (select a.*,tbC.StaffInfo_var_StaffName as StaffID from (select tbA.* ,tbB.CustomerName,tbB.Tel1,Isnull(tbB.Tel1,'')+'/'+Isnull(tbB.Tel2,'') as Tel from tbOBM_TaskList tbA left outer join tbCust_OB_No" + custTableID + " tbB on tbA.OBTask_int_CustomerID=tbB.InnerID)a left outer join (select * from tbStaff_StaffInfo(nolock) where isnull(StaffInfo_bit_IsDeleted,0)=0 and StaffInfo_int_Status=1) tbC on a.OBTask_int_DispatchStaffID= tbc.InnerID)b where b.OBTask_int_CallPlanID='" + callPlanID + "' and b.OBTask_bit_IsDeleted=0 and b.OBTask_int_StatusID< 7 and OBTask_int_ActualTryTimes<=OBTask_int_MaxTryTimes ) tb1";
把StaffInfo_var_StaffName列所有为aaa的数据显示出来,怎么加在这SQL语句里,因为太繁杂了看不懂