/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 vote267 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote282 views1 answer
Drush run sql select
SQL
3 votes281 views4 answers
Show databases in sql server
SQL
2 votes316 views1 answer
Pdo mysql insert
SQL
25 votes293 views5 answers
Date in mysql
SQL
0 vote272 views1 answer
Sqlite update where exists
SQL
1 vote265 views2 answers
Sql where is not number
SQL
0 vote279 views1 answer
Mysql update set sum
SQL
3 votes278 views1 answer
Define REGEXP?
SQL
0 vote299 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL