Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Print a table

Author  Topic 

Pinto
Aged Yak Warrior

590 Posts

Posted - 2006-07-06 : 06:59:28
Is there an easy way to print off a sql table ? I wanted something along the lines of an Access query that you can print. Or is it easiest to link to the SQL table and use Access to display it ?

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-07-06 : 07:08:14
Means you wanna print the records which are underlying the table??

if that so then , just select make a select query, copy the records from the Query Analyser grid to the Excel and then can print.



Chirag
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-06 : 08:55:38
Yeah, I like that....Link access to the database and go nuts

I find little use for "printing" a table however



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

Pinto
Aged Yak Warrior

590 Posts

Posted - 2006-07-06 : 11:20:52
Thanks for your replies. I just need a list as some fields are missing data and need completing. It's going to be a search to find the info. It's just a working copy I need, not a fancy 'pretty' report.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-07-06 : 12:58:39
Create a view and bcp the view out where col1 is null or col2 is null...etc



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page
   

- Advertisement -