Need help in micros 9700 SQL

[Jsmarty]

Dear All
I need help in micros 9700 sql2000
One of our customer needs data exported by micros database for the integretion from third party software they have mention following fields
restaurant name
date
total
count
reference
void
check#
and they want this on daily basis like todays business date

 

[IberRoot]

Is it running MSDE or native SQL2K?

 

[Jsmarty]

they are running SQL2k
if you have any batch file to create the export file please share that file to me

 

[IberRoot]

Grab a trial copy of pretty much any SQL Query Builder, trial works great, it will give you the ability to open a database, select a table, which fields and compile it in a SQL select statement and export selection to file in the structure they are asking you to, you can then run a scheduled event or get cocky and create a stored procedure and give them the trigger.