how to execute stored output to csv files

create Proc ExportTest
AS
BEGIN
SELECT * FROM EMPLOYEE

-- I NEED TO EXPORT RESULT OF THIS SELECT STATEMENT TO THE .CSV FILE
END