/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 vote237 views1 answer
Denied
SQL
-3 votes321 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote324 views1 answer
Get primary key of table
SQL
2 votes275 views1 answer
Username sql
SQL
0 vote289 views1 answer
Show create table in postgresql
SQL
0 vote289 views1 answer
Sql decode
SQL
0 vote292 views1 answer
Postgres copy command
SQL
0 vote313 views5 answers
How to make trigger in phpmyadmin
SQL
2 votes303 views2 answers
How to check database username and password in postgresql
SQL
0 vote279 views1 answer
Microsoft word insert sql code
SQL