/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 vote222 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote187 views1 answer
Postgres jsonb array push new element
SQL
0 vote463 views1 answer
Create pl/sql stored procedure
SQL
0 vote211 views1 answer
Delete hangfire retries list
SQL
4 votes188 views4 answers
Date less than in sql
SQL
0 vote192 views1 answer
Test the postgresql db connection
SQL
0 vote154 views1 answer
Oracle sysdba connect as another user
SQL
5 votes210 views2 answers
Postgresql add not null constraint
SQL
0 vote186 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
3 votes198 views2 answers
How to load files in mysql
SQL