/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 vote174 views1 answer
Grouping by email domain mysql
SQL
0 vote145 views2 answers
Null value in column violates not-null constraint
SQL
0 vote144 views1 answer
Check if database exists sql
SQL
1 vote141 views5 answers
Postgresql difference between two dates in days
SQL
2 votes144 views1 answer
How to get weekday from old date in sql
SQL
1 vote131 views2 answers
Grab part of a string sql
SQL
1 vote138 views1 answer
Mysql list bigger table
SQL
6 votes142 views3 answers
Mysql create database utf8
SQL
0 vote143 views1 answer
Automated psql csv export script on windows
SQL
1 vote144 views1 answer
Sqlite create index
SQL