Query Analyzer Results - Print with headings?????

Question

Query Analyzer Results - Print with headings?????

Oscar

Old Hand

Points: 359
More actions
February 6, 2005 at 11:27 pm

#66449

Environment.
SQL2k on Win2k server
I have a script that gives me the results I want. Now I want to print it.
Easy way to do it is to cut and paste into excel, but I loose the headings.
I know it has to be an easy way to get print the results with the headings.
Any ideas... will be greatly appreaciated!!!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47794 More actions · Answer 1

In Options on the Results tab, choose "Results to Text" and "Tab Delimited". This will give you the headings and data that you can cut & paste straight into Excel. Also, make sure you have SET NOCOUNT ON or you will have the "XXX rows..." message at the bottom.

Another tip, if you run your query in the Query Designer within EM, cutting and pasting from the results grid includes the column headings.

--------------------
Colt 45 - the original point and click interface

Henrik Litsne SSC-Addicted Points: 466 More actions · Answer 2

You could also do an export (defined by a query) directly to Excel.

/HL

Neuro Ten Centuries Points: 1063 More actions · Answer 3

an export to Excel defined by a query ....?

Please enlighten me maybe we're calling the same thing a rose?

Robert Bedick Old Hand Points: 310 More actions · Answer 4

QueryToDoc (http://www.querytodoc.com) will export query results (including column headings) to a table in a Word document.

Oscar Old Hand Points: 359 More actions · Answer 5

That look like a cool tool.

But for what I needed. Saving as text and tab delimeter did the trick for this one (maybe two) times deal.

If the request moves into a more regular basis, then I will look into these tools.

Thanks for your great help.

PS.

Now you got me looking!!

tal mcmahon-202603 SSC-Addicted Points: 474 More actions · Answer 6

don't forget that you can make an external datasourse in excel and just run the query. makes the data live.

tal

Marvin D SSCarpal Tunnel Points: 4058 More actions · Answer 7

Excel has some very cool ways of working with SQL Server. You could even connect and query utilizing a VBA script that runs when you load the spreadsheet. That is one of the great advantages of using the Microsoft Office Suite of programs. They all support VBA which enables you to manipulate and develop all sort of reports.

Marvin

Marvin Dillard
Senior Consultant
Claraview Inc

ZenDada SSCarpal Tunnel Points: 4637 More actions · Answer 8

Great tip Phill! We have been working with SQL Server for years and never thought of doing this. I just shared with my team. Thanks!

[font="Courier New"]ZenDada[/font]