/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 vote110 views1 answer
Getting next sequence value jpa postgress
SQL
-1 vote115 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote106 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes111 views1 answer
Oracle list duplicates
SQL
0 vote100 views1 answer
How to find symmetric pairs in sql
SQL
0 vote123 views3 answers
Insert query in ci
SQL
0 vote95 views1 answer
Alter column to not null with default value sql server
SQL
5 votes100 views1 answer
Postgresql functions
SQL
36 votes108 views6 answers
Delete from where sql
SQL
2 votes114 views1 answer
How to get weekday from old date in sql
SQL