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:
01453582
Views:
37
>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.

Select your query, right click, Select All, right click again, and then use Copy (with headers) and then paste into the Word.

Below is an example.
id	FirstColumn	LastColumn	SomeNumber	NewValue
1	A	B	10	10
2	C	D	20	30
3	E	F	30	60
4	G	H	40	100
The headers don't look aligned here in the messages area.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform