Cacher is the code snippet organizer for pro developers

alter PROC Utility_Rpt_EngineerAssessmentCountRoleWise
AS
BEGIN
	--DROP TABLE #Temp
	--SELECT * FROM vw_Mgr_rpt
	SELECT DISTINCT ee.Id
		,ee.Center
		,ee.Centers CenterName
		,tt.Test_Name WaveName
		,ee.MGRID AS MgrEmpId
		,ee.manager ManagerName
		,mgrUser.Email ManagerEmail
		,ee.empid AS EngEmpId
		,ee.NAME EngineerName
		,engUser.Email EngineerEmail
		,skill1 SkillName
		,test_id
		,CONVERT(VARCHAR(10), round(CONVERT(FLOAT, (
						(
							SELECT TOP 1 TIME
							FROM Test_Create_v3
							) - (
							SELECT MIn(TIME)
							FROM test_results_v3
							WHERE test_id = ee.test_id
							)
						)) / 60, 0)) + ' min' AS TimeTaken
		,ee.rating Rating
		,ee.PrimaryRole PrimaryRole
		,ee.SecondaryRole SecondaryRole
		,PrimaryServiceTower ServiceTower
	INTO #Temp
	FROM vw_Mgr_rpt ee
	JOIN TCI_Test_Name tt WITH (NOLOCK) ON ee.id = tt.id
	LEFT JOIN emp_master mgrUser ON mgrUser.empid = ee.MGRID
	LEFT JOIN emp_master engUser ON engUser.empid = ee.EMPID
	WHERE ee.Center = 'Global'
	ORDER BY ee.NAME

	--Total Assessments in Global Center: 13769
	SELECT count(*)
	FROM #Temp
	WHERE TimeTaken IS NOT NULL
		AND ISNUMERIC(rating) > 0
	--
	--How many eng have taken atleast one test in L1 :1693
	SELECT DISTINCT EngEmpId
	FROM #Temp em
	WHERE TimeTaken IS NOT NULL
		AND ISNUMERIC(rating) > 0
		AND em.SecondaryRole = 'zz[Secondary Only] Technical Remote Specialist'
		OR em.SecondaryRole = 'zz[Secondary Only] Technical Solution Specialist'

	--
	--How many eng have taken atleast one test in L2:419
	SELECT DISTINCT EngEmpId
	FROM #Temp em
	WHERE TimeTaken IS NOT NULL
		AND ISNUMERIC(rating) > 0
		AND em.SecondaryRole = 'zz[Secondary Only] Technical Solution Expert'
END