
July 12th, 2004, 01:16 PM
|
|
Registered User
|
|
Join Date: Dec 2003
Location: PA
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Ms Sql Select Count Distinct Probrem
I am trying to get the below query to work and can't seem to get past this error. Not sure but everywhere I look I think my syntax is right. I am probably missing something obvious but I'm just back from vacation and trying to get in the swing of things. Any help would be appreciated.
Select Distinct(chadcd) as Adjustor, Count (Distinct chclno) as NumberOfCases, Count (Distinct chclno,chwkno)as NumberofClauses
from clmhdr
where chpddt = '20040630'
Group By chadcd
Order by Adjustor
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ',chwkno'.
|