/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

1 vote160 views1 answer
Find logged in users mysql
SQL
0 vote167 views1 answer
Find all tables where column name exists oracle
SQL
150 votes515 views10 answers
Grepper
SQL
8 votes288 views2 answers
Oracle auto increment primary key
SQL
3 votes210 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote168 views1 answer
Postgres where
SQL
5 votes193 views4 answers
Rollback to in sql
SQL
0 vote230 views2 answers
Cascade syntax in sql
SQL
2 votes279 views1 answer
Postgresql group by month and year
SQL
3 votes136 views1 answer
Postgresql where current year
SQL