/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 vote194 views2 answers
Postgresql gset
SQL
2 votes181 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote175 views1 answer
Count mysql server db tables
SQL
1 vote201 views1 answer
Insert pg result of select
SQL
0 vote191 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote181 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote196 views1 answer
How much space does sql server take per row
SQL
1 vote181 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote191 views1 answer
How to get data from 2 database
SQL
0 vote203 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL