I need to export the results of this query into an xml table every 24 hours.
SELECT * from FRS_ACCESS FRS, EMPLOYEE EMP Where FRS.EMP_NBR = EMP.EMP_NBR
How do I automate this? We are using SQL SErver 2000, but will be migrating to 2005 in a few months.
Start Free Trial