/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 vote158 views1 answer
'0000-00-00' for column '
SQL
7 votes197 views4 answers
How to reset the identity column in sql server
SQL
6 votes229 views5 answers
Oracle list tablespaces
SQL
6 votes192 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
-2 votes218 views1 answer
How to open database
SQL
0 vote180 views1 answer
Dump only schema
SQL
1 vote234 views1 answer
Sql server insert into temp table
SQL
0 vote194 views1 answer
Sql case when exists in another table
SQL
-1 vote195 views3 answers
Update mongodb version ubuntu
SQL
0 vote196 views1 answer
Denormalise SQL command
SQL