/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 vote126 views1 answer
Sqlite insert or update
SQL
4 votes131 views2 answers
Linq join
SQL
16 votes129 views2 answers
Mysql date between two dates
SQL
5 votes116 views1 answer
Oracle sysdate - 1 month
SQL
0 vote75 views1 answer
Plsql trigger insert update
SQL
0 vote118 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote124 views1 answer
Connecting mySQL to STS
SQL
0 vote119 views8 answers
Convert sql query to linq online
SQL
0 vote109 views1 answer
Select top 3 sql
SQL
1 vote69 views1 answer
File /etc/init.d/mysql not exists
SQL