Try
SELECT rd.transaction_date,
0 as batchid,
tm.company_code as entityid,
count(*) as totrecs,
rdi.status,
rdi.used_by
FROM result_detail rd
JOIN telemrkt_company tm on rd.telemrkt_company = tm.id
LEFT OUTER JOIN result_detail_info rdi on rd.id = rdi.result_detail_id AND rdi.status IS NULL
GROUP BY rd.transaction_date, tm.company_code, rdi.status, rdi.used_by
ORDER BY company_code>Yes, here's the code:
>
>
>SELECT rd.transaction_date,
> 0 as batchid,
> tm.company_code as entityid,
> count(*) as totrecs,
> rdi.status,
> (CASE WHEN LEN(rdi.used_by)= 0 THEN NULL ELSE rdi.used_by END) AS used_by
>FROM result_detail rd
>JOIN telemrkt_company tm on rd.telemrkt_company = tm.id
>LEFT OUTER JOIN result_detail_info rdi on rd.id = rdi.result_detail_id AND rdi.status IS NULL
>GROUP BY rd.transaction_date, tm.company_code, rdi.status, rdi.used_by
>ORDER BY company_code
>
>
>
>
--sb--
