/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

12 votes177 views5 answers
Sql merge
SQL
0 vote186 views1 answer
Sql order by except one row
SQL
0 vote179 views1 answer
Mysql backup query
SQL
2 votes166 views1 answer
Sql alchemy or
SQL
0 vote164 views1 answer
Number(10 2) in sql means
SQL
1 vote203 views1 answer
Postgresql append array
SQL
0 vote196 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote170 views1 answer
Denormalise SQL command
SQL
2 votes153 views2 answers
Sqlite_busy: database is locked
SQL
0 vote182 views1 answer
Sql alter table add column if exists
SQL