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.