/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

8 votes252 views1 answer
Alter tablespace add datafile
SQL
18 votes263 views3 answers
Mysql number format
SQL
1 vote266 views1 answer
Alphabetical order mysql
SQL
2 votes259 views1 answer
Merge two columns in sql oracle
SQL
-1 vote271 views1 answer
Mysql case when multiple conditions
SQL
1 vote243 views10 answers
Stack overflow
SQL
2 votes251 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote254 views1 answer
Postgres truncate with cascade
SQL
3 votes279 views1 answer
Oracle list dates without weekends
SQL
6 votes266 views1 answer
Postgresql add enum value
SQL