hi ,I have 2 tables tblCallActivity and tblTimesheet.In tblCallActitvity i have ID,CaseID,CallStatus,HOremark,UpdatedBy,UpdatedOn.In tblTimesheet i have TimesheetID,Timesheetin,Timesheetout,EEmployeeID,CaseId,Allocatedcallstatus and Allotedon.Here it should Allot Scheduler for Tbltimesheet caseid's and It should allot Normal Update for tblCallActivity caseid's here i am using CASE for this query but its not working it display Only Normal Update here is my query.
SELECTCA.CaseID,CA.UpdatedOn,
CASE WHEN(SELECT TimesheetIdFROM tblTimesheetWHERE CaseId = CA.CaseID) > 0 THEN ‘NormalUpdate’ELSE ‘Scheduler’ENDFROM tblCallActivity CA where CallStatus=’ALLOTED’ Can any one plz help?