One more try
GROUP BY rd.transaction_date, tm.company_code, ISNULL(rdi.status, ''), ISNULL(rdi.used_by, '')
>Still only the one record.
>
>
>
>>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
>>
>>
--sb--
