/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

8 votes392 views2 answers
Update sql server from another table
SQL
0 vote372 views1 answer
Mysql shell ERROR: Not connected.
SQL
3 votes379 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
5 votes370 views5 answers
Sqlite install python
SQL
0 vote350 views1 answer
Database timezone
SQL
4 votes351 views4 answers
Update select mysql
SQL
0 vote369 views1 answer
On sql table data exists
SQL
6 votes417 views5 answers
Oracle list tablespaces
SQL
0 vote375 views1 answer
Oracle webcenter content search enginer
SQL
0 vote354 views1 answer
Many rows to 1 string mysql
SQL