• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

When using MSMSExpress, can I export my query results to a text file? rather than on the Results frame.

When using MSMSExpress, can I export my query results to a text file? rather than on the Results frame.

Question1:
I have a query called reports.sql that run smaller queries within, to give me some kind of a 2 page report, and it gives me the results okay in the Results window.  I would like to have the entire result in a text file, is that possible.

Question 2:
What is your best adivise of creating a Web Form report in Visual Studio 2008 SP1.  I have a web application that I would like to add a *.aspx page that when executed it will give me the results of a full page results of a custom query (same query as mentioned above), the query in question works with the same database, and opens many other small tables.  I was thinking in using formview, detailsview. repeater ???

Question 3.  In the same application mentioned in Question2, I need to create a Welcome Letter, where the letterhead and all content is the same, and I need to fill the field <name> on a specific spot in the letter.  Can you give me some directions on how to approach this,  is it easy to create a PDF with the results of the customized letter?

Thanks.
0
Aaron Thorn
Asked:
Aaron Thorn
  • 4
  • 2
1 Solution
 
jmoss111Commented:
Hello wrm-ag,

Actually you should ask only one question per question.

Regards,

Jim
0
 
Aaron ThornAuthor Commented:
Sorry about that, should I post it again?  All is part of the same application.
0
 
jmoss111Commented:
Basically EE says one question per post. You probably should break it up into separate questions because they aren't really related, and you're likely to get a better response. Don't take this the wrong way but it doesn't matter to me what you do.  I thought that it might help you out.

Regards,

Jim
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Aaron ThornAuthor Commented:
Thanks, Will follow your advise.
0
 
jmoss111Commented:
Thanks for the points but you could have had the question closed, and I don't mind if you want to get it closed and refund your points.

Jim
0
 
jmoss111Commented:
For #1 look at the BCP command which will output a text file
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now