/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

24 votes250 views6 answers
Sql change table name
SQL
0 vote213 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote230 views1 answer
Sql convert unix time to date
SQL
1 vote334 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote224 views2 answers
Sql max count
SQL
0 vote214 views1 answer
Components/Fields of Internal Table
SQL
9 votes218 views1 answer
Alter table column change data type to text mysql
SQL
0 vote231 views1 answer
How to print some string in mysql
SQL
2 votes219 views2 answers
How to check data type in sql server
SQL
0 vote201 views1 answer
Wordpress sql find and replace
SQL