quote:

---

Originally posted by nitsmooth

select

(case when MaterialsDate <> '' AND MaterialsDate <> ' ' AND MaterialsDate is not null
AND(countdt is null OR countdt ='' OR countdt =' ' OR COALESCE(countdt,GETDATE()) > CountDue) then callid end) as CountSLA
from
(
select cg.callid, dt.MaterialsDate, ag.groupname,sb.custid,
CONVERT(varchar(20), Dt.MaterialsDate + ' ' + Dt.MaterialsTime, 120) AS Materials,
CONVERT(varchar(20), Dt.CountDate + ' ' + Dt.CountTime, 120) AS Countdt,
CONVERT(varchar(20), Dt.Date3 + ' ' + Dt.Time3, 120) AS CountDue,
from calllog cg
join detail dt on cg.callid = dt.callid
join asgnmnt ag on ag.callid = dt.callid
join subset sb on sb.callid = cg.callid
where cg.calltype = 'Campaign' and cg.custtype = 'Company' and (Dt.ListName <> '')
AND (Dt.ListName IS NOT NULL)
)
T group by groupname


i want to create a case as:
before checking for countdt > CountDue
if the retrieved countdt is null then set countdt = getdate() then compare
otherwise compare with the already retrieved value not null countdt

How do i do that?

---