You can export data directly from a stored procedure by using xp_cmdshell and running a bcp command on the operating system.