	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.2

Save Query XML file

Asked by vb7guy in OpenXML_OXML, MS SQL Server, Scripting Languages

Hi, I have the following query that Generate the XML file using the For XML Auto, Root option. I can run this query and save the xml file to our network drive. But I would like to do all this by a Stored Procedure so that we can have a SQL job execute this Stored Procedure to run this script. In Addition, we also would like the xml file to be zipped up before saving it to network drive.
Any sample code would help.

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

           
           
             Use GiftRule
 
Select	filer_last_name		As LastName,
		filer_first_name	As FirstName,
		O_Office_Name		As OfficeName,
		F_Reporting_Year	As ReportingYear,
		F_Beg_Travel_Date	As BeginTravelDate,
		F_End_Travel_Date	As EndTravelDate,
		F_Date_Received		As DateReceived,
		F_Trans_Date		As TransactionDate,
		R_Title				As ReportTitle,
		F_Pages				As Pages
From	dbo.Document
Left
Join	dbo.filer
On		F_Filer_ID = filer_id
Left
Join	dbo.Office
On		F_Office_Id = O_Office_Number
Left
Join	dbo.Reports
On		F_Report_Code = R_Code
For XML Auto, Root ('GiftRule')

           
         

Related Solutions

Keywords: Save Query XML file

	Title
1	SQLCMD FOR XML AUTO
2	Whether Oralce supports anything link …
3	Export result of a query with transform…
4	AJAX Auto Complete Control
5	Need simple CRUD application using Fle…
6	google maps cities within raneg

Loading Advertisement...

20091118-EE-VQP-93 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. TheLearn...2,500
1. ahoffmann2,500
1. dejanpazin2,500
4. redrumkev2,000
4. acperkins2,000
4. war12,000
4. neilrichards2,000
4. mattayers082,000
4. sree_ven2,000
10. NULL_Re...1,500
10. tony_k1,500
12. Mestha1,200
13. jensfiederer1,000
13. LSMCons...1,000
15. milindn800
16. thinkpads...500

1. TheLearn...2,500
1. ahoffmann2,500
1. dejanpazin2,500
4. emoreau2,000
4. redrumkev2,000
4. acperkins2,000
4. meintsi2,000
4. war12,000
4. Brum072,000
4. clayfox2,000
4. neilrichards2,000
4. mattayers082,000
4. sree_ven2,000
14. julianmatz1,800
15. NULL_Re...1,500
15. tony_k1,500
17. Mestha1,200
18. jensfiederer1,000
18. LSMCons...1,000
20. milindn800
21. Echo_S500
21. thinkpads...500
23. RQuadling250

Save Query XML file

Asked by vb7guy in OpenXML_OXML, MS SQL Server, Scripting Languages

About this solution