/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 votes222 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote157 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote141 views1 answer
Sql upsert
SQL
5 votes155 views2 answers
Sql server check port number
SQL
0 vote142 views1 answer
Nth max in my sql
SQL
0 vote156 views1 answer
Sqlite3 get data from table c
SQL
15 votes177 views4 answers
Export mysql db using command line
SQL
5 votes203 views2 answers
Add days in oracle sql
SQL
7 votes181 views4 answers
Database dump mysql command
SQL
1 vote167 views1 answer
PL SQL MODIFY COLUMN NME
SQL