/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

3 votes205 views2 answers
How to start postgresql on windows
SQL
2 votes184 views1 answer
Codeigniter print last sql query
SQL
0 vote208 views1 answer
Look at running processes redshift
SQL
0 vote208 views1 answer
How to use group_concat in sql server
SQL
3 votes234 views5 answers
No module named 'MySQLdb'
SQL
1 vote197 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote191 views1 answer
Parsing float to int in mysql
SQL
3 votes325 views4 answers
Sql interview questions
SQL
11 votes223 views5 answers
Sql server reset identity
SQL
0 vote211 views1 answer
Insert ip address in mysql
SQL