Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy Query Results into WORD doc
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01453577
Message ID:
01453591
Views:
42
I did try the Save Results as... and wonder how I will do the rest of the instructions, as written below.

Here is specifically what she says in her instruction:

Run the query in Management Studio and copy the query result (with the # of rows affected) and paste it below the query in the Word document.

In Word, convert the copied text (query result) to a table by selecting only the query result rows (do not include the blank line and # of rows affected). Then click the Insert Table button from the standard toolbar in Office 2003, or click the Table from the Insert tabl in Office 2007 - Convert Text to Table.

Format the table by adjusting the column width (one line per row, best fit width), and right align only the numeric columns.

>Did you try 'Save Result As' from the File menu?

>>Our teacher for our SQL Server 2008 T-SQL class wants us to copy the Query results into a WORD DOC and then somehow convert it to a WORD table.
>>
>>First of all, I cannot seem to copy the Query results entirely, except with SnagIt and then save it as an image. So, how do I save the text, the record numbers and the Column Names, and then paste it into a WORD DOC and then convert it to a WORD Table? Believe me, I am trying to do this, but the typical, highlight and Copy isn't working.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform