Hello,
I have a SQL statement that Counts an nVarChar variable(COUNT(dboME.Name AS NumUsers)). I am trying to find the Sum of the results (NumUsers). Can any one point me in the right direction?
Printable View
Hello,
I have a SQL statement that Counts an nVarChar variable(COUNT(dboME.Name AS NumUsers)). I am trying to find the Sum of the results (NumUsers). Can any one point me in the right direction?
Not much information to go on but something like this
Select Count(dboME.[Name]) As NumUsers From dboME
Sorry here's the solution:
SELECT SUM(NumUsers) AS TotalUsers
FROM
(SELECT COUNT(dboMe.Name) AS NumUsers
FROM ...
GROUP BY ...) AS UserCount