/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

4 votes204 views2 answers
Oracle unlock account
SQL
0 vote260 views1 answer
Sqlalchemy query return only n results
SQL
0 vote199 views2 answers
Oracle create tablespace autoextend
SQL
13 votes175 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote167 views1 answer
Create bakupd database sqlserver
SQL
0 vote182 views1 answer
Oracle create table auto generated primary key
SQL
0 vote188 views4 answers
User defined function sql
SQL
57 votes832 views6 answers
Sql alter table
SQL
0 vote180 views1 answer
Start and stop mysql
SQL
0 vote174 views1 answer
Incorrect datetime value sql table error 1292
SQL