/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 vote166 views2 answers
Install sql server management studio ubuntu
SQL
0 vote164 views1 answer
C# sql transaction multiple connections
SQL
0 vote142 views1 answer
How to find sql server name
SQL
0 vote136 views1 answer
Psotgres multiple values
SQL
0 vote141 views1 answer
Get the First and Last Word from a String or Sentence
SQL
1 vote155 views1 answer
Select inside insert query
SQL
0 vote103 views1 answer
Postgres create database if not exists
SQL
0 vote141 views1 answer
Can sqldatareader be null
SQL
4 votes140 views2 answers
Delete all table oracle
SQL
2 votes141 views2 answers
Sql query to copy data from one column to another
SQL