Lynn Pettis! The 2nd Query is just for reference, that what I'm trying to get into the results. My main Table is tblGen_Users and UserID is PK, I've tried every logic, I can think; but no luck.

SELECT

A.SignedByUserID,

B.FullName,

COUNT(A.OutletID) AS TotalSignups,

DATENAME(Month, A.SignupDate) AS Month

FROM

dbo.tblGen_Users AS B LEFT OUTER JOIN

--The tblGen_Users contains all the values

dbo.tblMer_Outlet AS A ON B.UserID = A.SignedByUserID

--The tblMer_Outlet contains only the selected values

/* If the values from tblGen_Users are not available in tblGen_Merchant, the missing values must be displayed in the result mentioning 0 under COUNT */

WHERE

(A.SignupDate >= '2014-04-01 00:00:00') AND

(A.SignupDate <= '2014-04-30 23:59:59')

GROUP BY

A.SignedByUserID,

B.FullName,

DATENAME(Month, A.SignupDate)

ORDER BY

B.FullName