/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

6 votes148 views2 answers
Find mysql version linux
SQL
0 vote150 views1 answer
Mysql disable query caching
SQL
1 vote146 views1 answer
Mysql datetime with timezone offset
SQL
2 votes162 views2 answers
Postgresql search all tables for column name
SQL
0 vote156 views1 answer
Mysql 8 geo to json
SQL
0 vote218 views1 answer
Sql developer format sql
SQL
3 votes113 views4 answers
Mysql delete duplicate rows
SQL
4 votes146 views3 answers
Order by value mysql
SQL
0 vote160 views1 answer
If column value is null then in mysql
SQL
0 vote153 views2 answers
Psql commande \gset
SQL