/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 vote159 views2 answers
Compound operator in sql
SQL
2 votes146 views2 answers
Sql percentage
SQL
15 votes145 views3 answers
Mysql update add to existing value
SQL
0 vote149 views1 answer
Django mysqlclient connection string
SQL
23 votes138 views6 answers
Delete all rows from table sql
SQL
1 vote144 views1 answer
Sql into vs insert into
SQL
1 vote168 views2 answers
Create table if not exist
SQL
3 votes131 views2 answers
Pl sql escape '
SQL
0 vote155 views1 answer
How to find total working hour in sql
SQL
0 vote159 views1 answer
Create table like sql
SQL