/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

5 votes199 views2 answers
Oracle tables with column name
SQL
3 votes241 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote205 views1 answer
Ms sql database data size
SQL
0 vote206 views1 answer
Enable sql server full text indexing
SQL
0 vote212 views1 answer
Postgres get database encoding
SQL
2 votes219 views1 answer
Postgresql update sequence next value
SQL
0 vote230 views1 answer
Select new table sql
SQL
1 vote201 views2 answers
Sql select only first occurrence
SQL
25 votes212 views4 answers
Sqlserver add column
SQL
0 vote207 views1 answer
Power query case when
SQL