/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 vote248 views1 answer
Change redo log file size in mysql 5.6
SQL
5 votes410 views2 answers
How to ascending order in sql
SQL
1 vote212 views1 answer
Mysql find tables with column name
SQL
0 vote231 views2 answers
Wordpress change url after migration mysql query
SQL
13 votes272 views4 answers
Mysql remove foreign key constraint
SQL
0 vote196 views1 answer
How to find columns with null values in sql
SQL
-2 votes253 views3 answers
How to fetch first 10 rows in sql
SQL
1 vote182 views4 answers
Between vs in sql
SQL
1 vote209 views1 answer
Sql row having max
SQL
1 vote199 views1 answer
Sql order by where condition
SQL