i want to retrive yearly data in month format where if there is null entry in any month then it should be show zero value .I also used virtual table calender,but it wont worl properly?

WITH cte
AS (
	SELECT
		dt = DATEADD(DAY, -(DAY(@StartDate) - 1), @StartDate)

	UNION ALL

	SELECT
		DATEADD(MONTH, 1, dt)
	FROM
		cte
	WHERE
		dt < DATEADD(DAY, -(DAY(@EndDate) - 1), @EndDate))
SELECT
	CONVERT(char(3), dt, 100) + '/' + CONVERT(char(4), dt, 120) AS [month],
	CAST(0 AS decimal) AS Eqcount
INTO
	#AllMonthsData
FROM
	cte;

SELECT
	CONVERT(char(3), [Enquiry date], 100) + '/' + CONVERT(char(4), [Enquiry date], 120) AS [month],
	COUNT(enqno) AS Eqcount
INTO
	#AllAvailableEnquires
FROM
	Enquiry e
WHERE
	([Enquiry date] <= @StartDate)
	AND ([Enquiry date] >= @EndDate)
GROUP BY
	CONVERT(char(3), [Enquiry date], 100) + '/' + CONVERT(char(4), [Enquiry date], 120);

SELECT
	AMD.month,
	ISNULL(A.Eqcount,AMD.Eqcount) AS EqCount
FROM
	#AllMonthsData AMD
	LEFT JOIN #AllAvailableEnquires A ON AMD.month = A.month;

DROP TABLE #AllMonthsData;
DROP TABLE #AllAvailableEnquires;

SELECT cal.Months, COUNT(enqno) AS Enquiries
FROM #calendar cal
 LEFT JOIN enquiry
ON Month(cal.Months) = Month([enquiry date])
WHERE (YEAR([enquiry date])=YEAR(GetDate())) OR [enquiry date] IS NULL
GROUP BY cal.Months