select count (distinct X, Y)

From: Ronan (Ronan_at_discussions.microsoft.com)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 02:29:03 -0800

Hi all,

I'm trying to make this query:
select count (distinct UC_CODE, SYNT, SUPER)
FROM PLAN_RB
WHERE HYPER IS NULL
AND SUPER IS NOT NULL

and I have this message:
Incorrect syntax near ','

What I want to find is the total number of lines...

Do you know a way to solve this problem. It seems I cannot have several
values with a "count(distinct )" but I can't find any way to do it...

Thanks for your help.

Ronan

Relevant Pages

  • Query Process not showing users when not Admin
    ... Firstly apologies if you've read this in similar newsgroups - I've got nowhere ... with it and perhaps someone in here won't have seen my query before... ... I'm writing a simple script that a user can run to show them how many ... As super it comes out like this: ...
    (microsoft.public.windows.server.security)
  • RE: rename a Web application
    ... \par It is an expected behavior that the old url still works. ... \par Regarding your query, you can consider creating a new web application with the new name and then attach the old content database to the newly created web application. ... \par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: select count (distinct X, Y)
    ... >select count (distinct UC_CODE, SYNT, SUPER) ... >WHERE HYPER IS NULL ... >Incorrect syntax near ',' ... FROM (SELECT DISTINCT UC_Code, Synt, Super ...
    (microsoft.public.sqlserver.mseq)
  • Re: Wrong Calculations
    ... Here are the properties about the query I having problems with. ... SELECT reccln_07.usrdf1 AS Jobsite, reccln_07.usrdf2 AS Super, ... SumAS SumOfinvttl, ... My database is connected throught ODBC ...
    (microsoft.public.access.macros)