Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clubber
Starting Member
20 Posts |
 Posted - 2001-03-24 : 02:05:10
|
| I have this stored procedureselect Count(C.CompanyName)"Total" from Company C, City c , CompanyCity CC where @CityID = c.CityID and c.CityID = cc.CityID and cc.CompanyID= c.CompanyID group by C.CompanyName compute sum(count(C.CompanyName))And here si the result:Total ------------1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 (19 row(s) returned)sum ------------19 (1 row(s) returned)No rows affected.No more results.But all I want is 19 returned and not those whole bunch of 1's. This would have been ok but sum is not a column which I can reference from ASP. Is there any easy way to resolve this? Thanks |
|
|
|
|
|
Help with this stored procedure that counts record