I prefer using the BCP utility which is fast and offers a lot of flexibility. You have the option of configuring the row and column delimiters.

For more information, please refer...

Try this..

SELECT MONTH(OrderDate), COUNT(CustomerID) As ActiveCustomers

FROM v_Customer -- VIEW

GROUP BY MONTH(OrderDate)

ORDER BY OrderDate