/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 vote169 views10 answers
Stack overflow
SQL
0 vote169 views1 answer
Mysql subdate
SQL
3 votes174 views1 answer
Oracle list invalid password ORA-01017
SQL
7 votes171 views1 answer
Safe update mysql
SQL
0 vote164 views1 answer
Sql query to select records entered in last 24 hours
SQL
3 votes219 views1 answer
Sql select second max
SQL
0 vote172 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote184 views1 answer
Tsql pad left
SQL
0 vote220 views1 answer
Parent and child link in mysql
SQL
0 vote242 views1 answer
Migrations.RunSQL
SQL