/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 vote329 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote320 views1 answer
Sql DATE = GETDATE()
SQL
16 votes324 views2 answers
Sql exists
SQL
1 vote329 views2 answers
Group_concat limit mysql
SQL
0 vote396 views1 answer
Oracle simple quote
SQL
0 vote334 views1 answer
SQL Where-Klausel
SQL
1 vote313 views1 answer
Events mysql
SQL
1 vote299 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
3 votes298 views1 answer
Sql select all
SQL
0 vote328 views1 answer
How to start my sql server on mac
SQL