/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

2 votes180 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote197 views3 answers
Insert query in ci
SQL
15 votes247 views3 answers
Create table with primary key auto increment in sql
SQL
2 votes180 views1 answer
Wait delay in sql server
SQL
0 vote185 views1 answer
How to check replication lag in mySQL
SQL
0 vote134 views1 answer
Get all stored procedures in sql server
SQL
0 vote182 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote248 views1 answer
Radius search with point data in mysql
SQL
0 vote175 views1 answer
Change database name psql 8
SQL
11 votes186 views1 answer
Sql query to find duplicates in column
SQL