COUNT many but display just once?

Hi, I have a table that I insert a member's country into every time
someone signs up. What I'd like to do is pull information from the DB
such that I can see each country and the number of users from each.
For example:

Argentina 10
Brazil 5
Canada 3

I'm having trouble writing the SQL for this...any suggestions?

Thanks,

Erik
"Erik Lautier" <lautier@.gmail.comwrote in message
news:1177283677.045638.109480@.o5g2000hsb.googlegro ups.com...

Quote:

Originally Posted by

Hi, I have a table that I insert a member's country into every time
someone signs up. What I'd like to do is pull information from the DB
such that I can see each country and the number of users from each.
For example:
>
Argentina 10
Brazil 5
Canada 3

W/o schema it's impossible to say what you want for sure but something like

create table membership
(
country varchar(20),
signup varchar(20)
);

insert into membership values ('Argentina', 'member 1')
insert into membership values ('Argentina', 'member 2')
insert into membership values ('Brazil', 'member 1')
insert into membership values ('Brazil', 'member 1')
insert into membership values ('Brazil', 'member 2')
insert into membership values ('Brazil', 'member 3')
insert into membership values ('Canada', 'member 1')

select country, count(signup) from membership group by country

SELECT COUNTRY, COUNT(signup) from membership group by country

Quote:

Originally Posted by

>
I'm having trouble writing the SQL for this...any suggestions?
>
Thanks,
>
Erik
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||That did the trick. Thanks!

On Apr 22, 8:23 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.comwrote:

Quote:

Originally Posted by

"Erik Lautier" <laut...@.gmail.comwrote in message
>
news:1177283677.045638.109480@.o5g2000hsb.googlegro ups.com...
>

Quote:

Originally Posted by

Hi, I have a table that I insert a member's country into every time
someone signs up. What I'd like to do is pull information from the DB
such that I can see each country and the number of users from each.
For example:

>

Quote:

Originally Posted by

Argentina 10
Brazil 5
Canada 3

>
W/o schema it's impossible to say what you want for sure but something like
>
create table membership
(
country varchar(20),
signup varchar(20)
);
>
insert into membership values ('Argentina', 'member 1')
insert into membership values ('Argentina', 'member 2')
insert into membership values ('Brazil', 'member 1')
insert into membership values ('Brazil', 'member 1')
insert into membership values ('Brazil', 'member 2')
insert into membership values ('Brazil', 'member 3')
insert into membership values ('Canada', 'member 1')
>
select country, count(signup) from membership group by country
>
SELECT COUNTRY, COUNT(signup) from membership group by country
>
>
>

Quote:

Originally Posted by

I'm having trouble writing the SQL for this...any suggestions?

>

Quote:

Originally Posted by

Thanks,

>

Quote:

Originally Posted by

Erik

>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Could not start the MSSQLServer Service on local computer. Error: 1068: the dependency ser

We installed SQL Server 2000 on a Win2000 server (call it serverA). This
Win2000 server used to be a member server of a Domain Controller (call it
serverDC with domain name DCName). We had a problem with that Domain
Controller today, so we took out serverA from the domain controller. Now, we
cannot start the SQL Server Service Manager. It gave us an error that says
"Dependency service or group failed to start. Error 1068 (Dependency service
or group failed to start) occured while performing this service operation on
the MSSQLServer Service.".
When I tried to srtart the MSSQLServer Service, it gave me an error "Could
not start the MSSQLServer Service on local computer. Error: 1068: the
dependency service or group failed to start". When I clicked on the tab
"Dependencies", there is no dependency for this service.
On the "Log On" tab of MSSQLServer Service, the user name used to say
"DCName\Administrator", and after we took out serverA from the domain
controller, we changed the user name to "\Administrator".
How can I fix this problem ? Thank you.Try changing the services (SQL Server, SQL Agent, etc) to
run under Local System - from the Log On tab of the service.
You wouldn't necessarily want to keep it set to this but you
can see if it's starts up with the services running under
local system.
-Sue
On Tue, 7 Sep 2004 14:49:06 -0500, "Fie Fie Niles"
<fniles@.wincitesystems.com> wrote:
>We installed SQL Server 2000 on a Win2000 server (call it serverA). This
>Win2000 server used to be a member server of a Domain Controller (call it
>serverDC with domain name DCName). We had a problem with that Domain
>Controller today, so we took out serverA from the domain controller. Now, we
>cannot start the SQL Server Service Manager. It gave us an error that says
>"Dependency service or group failed to start. Error 1068 (Dependency service
>or group failed to start) occured while performing this service operation on
>the MSSQLServer Service.".
>When I tried to srtart the MSSQLServer Service, it gave me an error "Could
>not start the MSSQLServer Service on local computer. Error: 1068: the
>dependency service or group failed to start". When I clicked on the tab
>"Dependencies", there is no dependency for this service.
>On the "Log On" tab of MSSQLServer Service, the user name used to say
>"DCName\Administrator", and after we took out serverA from the domain
>controller, we changed the user name to "\Administrator".
>How can I fix this problem ? Thank you.
>

Could not connect server from client machine

Hi all

I m a new member to this forum. Im a hardware engineer who rectify aome software related issues. Now our employees having problem with connecting their XP prof based clients to 2003 server from SQL query analyzer. I tried refresh sql server manager in server and tried restarting the server machine many times. sometimes it the client machine connects and disconnects immediately. i aslo tried changing the poll interval , but no use.

waiting for a speedy solutin... i know this is as easy query.

Hi mvramsubbu,

A warm welcome to forum

You need to digg more to get the Exact erro message refer Windows Event Viewer and SQL Server's Error Log for error and post them here so that you can get a good answer. unless you post the error message we can not help you.

Hemantgiri S. Goswami