/SQL/Sql server isnull function nor working count

Sql server isnull function nor working count

SELECT  FirstName, 
        LastName,
        IsNull((
            SELECT  COUNT(UP1.EmailAddress) AS HasEmail 
            From    dbo.UserProfiles AS UP1 
            WHERE   (NOT (UP1.EmailAddress IS NULL)) 
                    AND (CreatedBy = dbo.UserProfiles.UserID)
            GROUP BY CreatedBy), 0) AS EmailEnteredCount 
FROM    dbo.UserProfiles 
WHERE   (IsStaff = 1)

Source: stackoverflow.com

Similar codes

1 vote371 views1 answer
Store select query result in variable sql server
SQL
1 vote372 views1 answer
Pgsql sum switch case
SQL
0 vote356 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote362 views4 answers
First max salary in sql
SQL
7 votes353 views2 answers
Mysql default value
SQL
0 vote365 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote326 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote368 views1 answer
Oracle grant on all tables in schema
SQL
-1 vote359 views3 answers
SQL to LINQ converter
SQL
4 votes343 views1 answer
Sql query to make a existing column auto increment
SQL