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 - 2003-06-19 : 11:09:37
|
| naveed writes "hi sqlteam,greetings.how can i take data from the following 1.mytable (column =item_no) 2.MyStoredProc (its stored procedure having item_no, date of purcase, and etc.)what i need to fetch the data from these two sourcesin a single statement." |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-06-19 : 12:28:11
|
| You cannot join a table on a stored procedure. You can get out both in ADO by using the Nextrecordset method, and passing two commands, or why not have your stored procedure return the table data as well?Sarah Berger MCSD |
 |
|
|
|
|
|
Sql Queries