/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

1 vote270 views1 answer
Postgres set sequence value to max id
SQL
9 votes243 views6 answers
Sql insert into
SQL
0 vote253 views2 answers
Null value in column violates not-null constraint
SQL
22 votes283 views3 answers
Year format in date mysql
SQL
0 vote270 views1 answer
QUERY JPQL
SQL
0 vote246 views1 answer
Change default schema sql server
SQL
2 votes263 views1 answer
Oracle apex list connected users
SQL
0 vote270 views1 answer
Code to move ietms from one table to another myswl
SQL
3 votes244 views1 answer
Search for column name in psql
SQL
1 vote261 views1 answer
Postgres convert date to string
SQL