/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 vote241 views1 answer
Sql alchemy escape ; in insert statement
SQL
7 votes235 views6 answers
Nth highest salary in sql
SQL
25 votes218 views6 answers
Modify column name in mysql
SQL
1 vote245 views1 answer
Postgres left join
SQL
8 votes234 views1 answer
Oracle tablespace datafile max size
SQL
10 votes243 views2 answers
SQL rounding numbers
SQL
0 vote235 views1 answer
Sql server check whether column has same equal values
SQL
0 vote214 views1 answer
Sqldf change user
SQL
-1 vote233 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote239 views1 answer
Will graphql replace sql
SQL