AGENT-20
یک شنبه 22 اردیبهشت 1392, 10:40 صبح
سلام
من موقع استفاده از یونیون در ی فیلد کامنت اگر توضیحاتش زیاد باشه همه رو نشون نمیده
اما بدون یونیون کامل سلکت میکنه
میگید چه کنم؟؟
query = "select EmployeeName AS QualityName,tbl_Agent.AgentID,UserName,Nam,City,Mo nitorID,tbl_Monitoring.WorkID,Pilot,SN,CallNO,Call Date,CallTime,CallDuration,Cat,Summary,Result,Hang Up,MonitorDuration,Comment,DateInsert,TimeInsert from tbl_Monitoring,tbl_Agent,View_Employee_Select,tbl_ WorkID,tbl_CityAgent Where tbl_Monitoring.QualityID=View_Employee_Select.Empl oyeeID AND tbl_Agent.AgentID=tbl_Monitoring.AgentID AND tbl_Agent.CityID=tbl_CityAgent.CityID AND tbl_Monitoring.WorkID=tbl_WorkID.WorkID AND DateInsert >= '" + FromDate + "' AND DateInsert <= '" + ToDate + "'";
query += " UNION select EmployeeName AS QualityName,tbl_Agent.AgentID,UserName,Nam,City,Mo nitorID,tbl_Monitoring.WorkID,'-',SN,CallNO,CallDate,CallTime,CallDuration,Cat,Sum mary,Result,HangUp,MonitorDuration,Comment,DateIns ert,TimeInsert from tbl_Monitoring,tbl_Agent,View_Employee_Select,tbl_ CityAgent Where tbl_Monitoring.QualityID=View_Employee_Select.Empl oyeeID AND tbl_Agent.AgentID=tbl_Monitoring.AgentID AND tbl_Agent.CityID=tbl_CityAgent.CityID AND WorkID NOT IN (select WorkID from tbl_WorkID ) AND DateInsert >= '" + FromDate + "' AND DateInsert <= '" + ToDate + "'";
من موقع استفاده از یونیون در ی فیلد کامنت اگر توضیحاتش زیاد باشه همه رو نشون نمیده
اما بدون یونیون کامل سلکت میکنه
میگید چه کنم؟؟
query = "select EmployeeName AS QualityName,tbl_Agent.AgentID,UserName,Nam,City,Mo nitorID,tbl_Monitoring.WorkID,Pilot,SN,CallNO,Call Date,CallTime,CallDuration,Cat,Summary,Result,Hang Up,MonitorDuration,Comment,DateInsert,TimeInsert from tbl_Monitoring,tbl_Agent,View_Employee_Select,tbl_ WorkID,tbl_CityAgent Where tbl_Monitoring.QualityID=View_Employee_Select.Empl oyeeID AND tbl_Agent.AgentID=tbl_Monitoring.AgentID AND tbl_Agent.CityID=tbl_CityAgent.CityID AND tbl_Monitoring.WorkID=tbl_WorkID.WorkID AND DateInsert >= '" + FromDate + "' AND DateInsert <= '" + ToDate + "'";
query += " UNION select EmployeeName AS QualityName,tbl_Agent.AgentID,UserName,Nam,City,Mo nitorID,tbl_Monitoring.WorkID,'-',SN,CallNO,CallDate,CallTime,CallDuration,Cat,Sum mary,Result,HangUp,MonitorDuration,Comment,DateIns ert,TimeInsert from tbl_Monitoring,tbl_Agent,View_Employee_Select,tbl_ CityAgent Where tbl_Monitoring.QualityID=View_Employee_Select.Empl oyeeID AND tbl_Agent.AgentID=tbl_Monitoring.AgentID AND tbl_Agent.CityID=tbl_CityAgent.CityID AND WorkID NOT IN (select WorkID from tbl_WorkID ) AND DateInsert >= '" + FromDate + "' AND DateInsert <= '" + ToDate + "'";