Query On Case Statement

Sathya Narayan

11y900

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.

SELECT
CA.CaseID,
CA.UpdatedOn,

CASE WHEN
(
SELECT TimesheetId
FROM tblTimesheet
WHERE CaseId = CA.CaseID
) > 0 THEN ‘NormalUpdate’
ELSE ‘Scheduler’
END
FROM tblCallActivity CA where CallStatus=’ALLOTED’ Can any one plz help?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
If you found anything useful please accept the answer.
0
Sathya Narayan11y ago
Hi Manas Mahapatra,

Thanks for your reply the query has been working fine

Regards,

sathya
0
Manas Mohapatra11y ago
Try below query:

SELECT
CA.CaseID,
CA.UpdatedOn,
CASE WHEN
(
SELECT COUNT(TimesheetId)
FROM tblTimesheet
WHERE CaseId = CA.CaseID
) > 0 THEN 'NormalUpdate'
ELSE 'Scheduler'
END
FROM tblCallActivity CA where CallStatus = 'ALLOTED'

If it doesn't resolve your problem then provide some demo data with two and elaborate what you need in result.
0