/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

9 votes306 views2 answers
SELECT User,Host FROM mysql.user;
SQL
1 vote427 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote317 views1 answer
Distance calculator from lat long sql query
SQL
0 vote290 views1 answer
How to combine first and last nae into one columb sql
SQL
7 votes271 views2 answers
Sql server drop temp table if exists
SQL
0 vote279 views1 answer
Sqlalchemy query return only n results
SQL
3 votes299 views2 answers
To_char sql
SQL
1 vote241 views1 answer
Ms sql how to see active job current run time
SQL
0 vote287 views1 answer
Sql datediff db2
SQL
0 vote267 views1 answer
Get first name and last name from full name string in SQL
SQL