|
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...
Navigation:
[Reply to this message]
|