SQL - customer orders by month

customer_orders.sql

DECLARE @sql NVARCHAR(max), @selects NVARCHAR(max)
SET @sql = 'SELECT ';
SET @selects = '';

SELECT @selects = COALESCE(@selects + ', ', '') + ' (SELECT COUNT(DISTINCT O.OrderID)
		FROM Orders O		
		WHERE O.CustomerID = C.CustomerID	   		
		AND O.OrderDate BETWEEN ''' + convert(NVARCHAR(MAX), [start_date], 102) + 
		''' AND ''' + convert(NVARCHAR(MAX), [end_date], 102) + ''' ) AS [' + [date_text] + ']' + CHAR(13)
FROM #dates ;

SET @sql = 'SELECT C.ContactName ' + @selects + 
		   ' FROM Customers C';

print @sql
EXECUTE sp_executesql @sql

Use this https://gist.github.com/mizrael/c44e575008f5ab98994f to generate the #dates table