/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

6 votes225 views1 answer
Sqlite foreign key
SQL
0 vote195 views1 answer
Sql new line output
SQL
3 votes244 views1 answer
Unsigned int in mysql
SQL
1 vote238 views1 answer
Float precision in psql
SQL
0 vote251 views1 answer
Sql get count without group by
SQL
11 votes227 views2 answers
MySQL DISTINCT
SQL
28 votes194 views6 answers
Distinct sql
SQL
0 vote254 views1 answer
Proc sql not in working
SQL
2 votes248 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
2 votes238 views1 answer
Copy all values of a column to another column in sql in same table
SQL