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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-23 : 07:37:15
|
| ajay writes "i have to pass a date parameter in procedure (sql) and whatever result will appear on the screen i want to printfor examplecreate procedure mysql as select * from <xtable> where date <= <parameter date> 'whatever result will appear on the screen i want to print it I don't have any idea about VB" |
|
|
teej
Starting Member
9 Posts |
Posted - 2005-09-23 : 09:08:35
|
| You could use a batch file and pass the parameter as a variable. Use the osql utility (you can find details in SQL help) to run the query and return the results to a text file and then use the DOS print command to print the file.http://www.computerhope.com/printhlp.htm#04If you need to run this from sql use xp_cmdshell to run the batch file. |
 |
|
|
|
|
|
regarding passing parameter & printing the procedure