Sql server isnull function nor working count

This article is tagged with: Sql server isnull function nor working count and mysql

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)

This article is tagged with: Sql server isnull function nor working count and mysql