/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 vote289 views1 answer
Timestamp(0) postgresql
SQL
1 vote280 views1 answer
Select tables with name like mysql
SQL
7 votes285 views5 answers
Sql remove spaces
SQL
0 vote286 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote268 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
-1 vote272 views1 answer
Count occurrences sql
SQL
7 votes278 views2 answers
Oracle foreign key reference table
SQL
3 votes312 views2 answers
Truncate table
SQL
0 vote277 views1 answer
Sqlite get date only
SQL
14 votes296 views4 answers
Import database through command line
SQL