Posted by laurenq uantrell on 11/22/05 17:51

I'm trying to return an integer from the following table that returns
the number of unique cities:


tblEmployees
Name City
John Boston
Frank New York
Jim Omaha
Betty New York

The answer should be 3.

DECLARE @EmployeeCities int

SELECT @EmployeeCities = SELECT ... ???

How go I return one row/column into @EmployeeCities from a Count and a
GroupBy?

Headache already... Maybe it's too early...

[Back to original message]