Posted - 10/09/2014 : 13:07:39
I need to have an automated extract from a sql 2000 who creates me .csv file
every end of the month.
Unfortunately the DB is an SQl 2000 .
so im not the Power Admin of SQL 2000.
Any one a ideas how it can create this extract job on a SQL DB?
Following Query will be used:
from PosHeader PH
JOIN PosTransactions PT
ON PH.HeaderID = PT.HeaderID
JOIN PosLoyaltyCusts PLC
ON PT.GlobalTxnID = PLC.GlobaltxnID
WHERE PT.IsVoided = 0
AND PT.IsTranining = 0 and Ph.WorkDate between '2014-06-30 00:00:00' and '2014-09-28 00:00:00'
Hope some one have any idications how i can relase this on the SQL 2000.