/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

1 vote332 views2 answers
Insert sqlite
SQL
1 vote277 views1 answer
Restart identity postgresql
SQL
0 vote345 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote301 views1 answer
Default column value in sql same as other column
SQL
25 votes329 views6 answers
Modify column name in mysql
SQL
2 votes331 views1 answer
Tsql copy table
SQL
1 vote315 views1 answer
Mysql f# examples
SQL
1 vote368 views1 answer
Floor function in sql oracle
SQL
0 vote347 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote332 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL