/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

0 vote362 views2 answers
Create row number in sql
SQL
1 vote347 views1 answer
Mysql check if string contains comma separated
SQL
0 vote282 views1 answer
Check if due date is less than todays date sql
SQL
1 vote370 views2 answers
One to one and one to many relationship
SQL
7 votes354 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote337 views1 answer
Start and stop mysql
SQL
0 vote339 views1 answer
Sql server list user permissions
SQL
0 vote351 views1 answer
How to declare variable date in mysql
SQL
14 votes356 views1 answer
Oracle new column
SQL
0 vote376 views1 answer
Pl sql disable trigger
SQL