Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2008-11-12
6
Medium Priority
?
184 Views
Last Modified: 2013-11-27
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
Comment
Question by:Aaron Thorn
  • 4
  • 2
6 Comments
 
LVL 18

Expert Comment

by:jmoss111
ID: 22946584
Hello wrm-ag,

Actually you should ask only one question per question.

Regards,

Jim
0
 

Author Comment

by:Aaron Thorn
ID: 22946852
Sorry about that, should I post it again?  All is part of the same application.
0
 
LVL 18

Accepted Solution

by:
jmoss111 earned 2000 total points
ID: 22946981
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Closing Comment

by:Aaron Thorn
ID: 31516212
Thanks, Will follow your advise.
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 22947050
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
 
LVL 18

Expert Comment

by:jmoss111
ID: 22947071
For #1 look at the BCP command which will output a text file
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question