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-02-03 : 08:47:15
|
| dan writes "I have a stored procedure which collects together data from eight different tables and puts it all into a temporary table. It returns the rows using "Select * From #tab1" as the last statement. It worked fine for months, sending the data into a VB6 ADO recordset. Then it stopped working. No errors were forthcoming, just completely empty recordsets. I rewrote the whole thing after discovering functions and the table datatype (I wrote a function to return a table to a stored procedure which returned the table to an ADO Recordset. I don't like it either, but it works). I can't for the life of me figure out why everything stopped working in the first place. Any ideas ?" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-03 : 10:07:50
|
| It's kind of hard to respond...very broad brush you've used here...can you post a url of the s/p, or post it so we can see what's going on?Brett8-) |
 |
|
|
|
|
|
Returning rows from a temporary table