How do I export SQL data into a text delimited file using SQL 2000? Need the script.
SELECT date,customer_id,office,region
FROM customer
where date = '2008-07-10'
ORDER BY date
Need data in a text file like this:
date,customer_id,office,region
01/19/2008,70188,4,11
01/21/2008,70188,14,28
01/22/2008,70188,19,35
01/23/2008,70188,12,34
01/24/2008,70188,6,20
01/25/2008,70188,19,42
01/26/2008,70188,,8
01/28/2008,70188,22,47
01/29/2008,70188,9,36
01/30/2008,70188,,24
01/31/2008,70188,12,40
02/01/2008,70188,16,42
02/02/2008,70188,,11