/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

5 votes189 views1 answer
Oracle columns in all_tables
SQL
1 vote190 views1 answer
Get rows affected mysql python
SQL
2 votes193 views1 answer
Sqlplus clear screen
SQL
0 vote191 views1 answer
Start and stop mysql
SQL
0 vote190 views1 answer
MySql count occurences more than"
SQL
22 votes217 views4 answers
Date format mysql
SQL
0 vote254 views1 answer
Sql server query all database objects
SQL
2 votes183 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
6 votes175 views1 answer
Oracle rank() over (partition)
SQL
0 vote224 views1 answer
Mysqldump: error:
SQL