oh oh oh, Don't I feel silly

Thanks




>The '.' (dot) is invalid character for SQL Server objects names
>

>--       (CASE WHEN LEN(rdi.BatchNo)= 0 THEN '' ELSE rdi.Used_By END) AS rdi.Used_By
>         (CASE WHEN LEN(rdi.BatchNo)= 0 THEN '' ELSE rdi.Used_By END) AS Used_By
>

>>
>>This was working Ok, then I added the JOIN to Result_Detail_Info. I now get the error:
>>"Line 11: Incorrect syntax near '.'."
>>
>>Here's the code:
>>
>>

>>SELECT rd.create_date,
>>       rd.transaction_date,
>>       0 as batchid,
>>       rd.telemrkt_company,
>>       tm.company_code,
>>       count(*) as Cnt,
>>       rdi.status,
>>       rdi.used_by,
>>       (CASE WHEN LEN(rdi.BatchNo)= 0 THEN '' ELSE rdi.Used_By END) AS 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
>>WHERE rdi.status IS NULL
>>GROUP BY rd.create_date, rd.transaction_date, rd.telemrkt_company, tm.company_code, rdi.status, rdi.used_by, rdi.process_batch
>>ORDER BY company_code
>>