Advertisement

05.08.2008 at 07:04AM PDT, ID: 23386079
[x]
Attachment Details

How to Automate Export of Table Data to an XML file?

Asked by tcannon in Extensible Markup Language (XML), MS SQL Server

Tags:

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
[+][-]05.08.2008 at 07:07AM PDT, ID: 21524797

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 07:22AM PDT, ID: 21524960

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 07:30AM PDT, ID: 21525033

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 11:16AM PDT, ID: 21527092

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 01:41AM PDT, ID: 21531151

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 08:11AM PDT, ID: 21574502

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.28.2008 at 01:12PM PDT, ID: 21663923

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Extensible Markup Language (XML), MS SQL Server
Tags: SQL Server VN.NET
Sign Up Now!
Solution Provided By: tcannon
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628