/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

0 vote128 views1 answer
Find wordpress version in database
SQL
0 vote111 views1 answer
Jooq replace
SQL
5 votes122 views1 answer
Oracle list days between two dates
SQL
1 vote125 views1 answer
Mysql workbench in ubuntu 14.04
SQL
15 votes118 views3 answers
Find duplicate keys in mysql
SQL
0 vote134 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote123 views1 answer
SQL: calculate hours from two dates
SQL
0 vote123 views1 answer
Drop index in sql
SQL
0 vote124 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
1 vote127 views1 answer
Postgres left join
SQL