------------------------------------------------------------------------------
IF OBJECT_ID('tempdb..#EmpTenure') IS NOT NULL
	DROP TABLE #EmpTenure
------------------------------------------------------------------------------
CREATE TABLE #EmpTenure
(
	emp_id			INT
	, months_tenure		INT
	, term_date		DATETIME
	, PRIMARY KEY (emp_id)
)

INSERT INTO #EmpTenure SELECT 11111, 3, '1/1/2011'
INSERT INTO #EmpTenure SELECT 22222, 3, '2/2/2011'
INSERT INTO #EmpTenure SELECT 33333, 5, '3/3/2011'
INSERT INTO #EmpTenure SELECT 44444, 6, '4/4/2011'
INSERT INTO #EmpTenure SELECT 55555, 8, '5/5/2011'
INSERT INTO #EmpTenure SELECT 66666, 8, '6/6/2011'
INSERT INTO #EmpTenure SELECT 77777, 8, '7/7/2011'
------------------------------------------------------------------------------
SELECT
	e.months_tenure
	, [total_employees] = Count(*)
FROM #EmpTenure e
WHERE term_date <= getdate()
GROUP BY e.months_tenure
ORDER BY e.months_tenure
------------------------------------------------------------------------------

months_tenure     total_employees
---------------------------------
      3                  2
      5                  1
      6                  1
      8                  3

months_tenure     total_employees
---------------------------------
      3                  2
      4                0
      5                  1
      6                  1
      7                0
      8                  3

DECLARE @t TABLE (months_tenure INT)
INSERT	@t
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4 UNION ALL
SELECT 5 UNION ALL
SELECT 6 UNION ALL
SELECT 7 UNION ALL
SELECT 8

SELECT	t.months_tenure, [total_employees] = Count(e.emp_id)
FROM	@t t
LEFT JOIN (
	SELECT	emp_id, months_tenure
	FROM	#EmpTenure
	WHERE	term_date <= getdate()
) e
On	e.months_tenure = t.months_tenure
GROUP	BY t.months_tenure
ORDER	BY t.months_tenure