/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 vote240 views2 answers
Clauses in mysql
SQL
0 vote214 views1 answer
TSQL convert csv to table
SQL
0 vote210 views1 answer
Prodection ready postgres database step by step
SQL
5 votes262 views2 answers
Mysql where in array
SQL
1 vote220 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote210 views2 answers
Sql drop multiple columns if exists
SQL
1 vote192 views2 answers
How to check username in mysql command line
SQL
8 votes190 views5 answers
Grant permission in postgres
SQL
8 votes216 views1 answer
Mysql limit rows
SQL
10 votes214 views4 answers
How to alter table name in mysql
SQL