/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

0 vote138 views1 answer
Sql server create constraint
SQL
0 vote138 views2 answers
Reseed sql identity
SQL
0 vote134 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote122 views1 answer
Alter precision
SQL
1 vote142 views2 answers
Mysql extract number from string
SQL
1 vote117 views1 answer
What is intersect
SQL
2 votes120 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote122 views1 answer
Psql select * from table
SQL
0 vote136 views1 answer
To_date sql
SQL
0 vote166 views1 answer
Sqlalchemy orm duplicate
SQL