/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

36 votes368 views6 answers
Delete from where sql
SQL
1 vote337 views1 answer
Sql avg group by
SQL
1 vote389 views2 answers
Postgresql check privileges on schema
SQL
11 votes356 views1 answer
Sql query to find duplicates in column
SQL
-1 vote338 views3 answers
Psql get last rows
SQL
-1 vote372 views5 answers
Left join
SQL
2 votes331 views1 answer
Select from array in psql
SQL
5 votes333 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote344 views1 answer
Oserror mysql_config not found virtualenv
SQL
13 votes346 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL