/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 vote285 views1 answer
Procedures and functions in pl/sql
SQL
0 vote610 views1 answer
Power bi connect to postgresql
SQL
0 vote261 views2 answers
How to combine two sql queries in one result
SQL
1 vote319 views1 answer
Mysql select and count left join
SQL
0 vote289 views1 answer
Database springboot
SQL
2 votes372 views3 answers
Mysql unix timestamp to date
SQL
0 vote275 views1 answer
Sql requete number pair
SQL
0 vote362 views1 answer
Sql query for login with email or username
SQL
0 vote294 views1 answer
Update set with inner join oracle
SQL
1 vote380 views2 answers
Copy table in sql
SQL