Exporting a table to CSV format... job? stored prod?
Posted on 2007-03-24
We have clients that will need their position in csv format a handful of times over the next week or two. So, we need to figure out how to export positions from SQL to CSV for the following starting with AA(like statement will grab everything starting with AA, etc), AE and CF. I created a query to show the following data that i need for the next 2 weeks.
WHERE (root LIKE 'AA%') OR
(root LIKE 'AE%') OR
(root LIKE 'CF')
I do not want to do this manually everyday. Soo i want to schedule a job to run export the data maybe a DTS package and save it as a CSV? Do i need to create a Stored procedure or something? If so how do i do that?
Sorry I am new to SQL and ideas?????? Thank you again!