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 |
|
sotian
Starting Member
8 Posts |
 Posted - 2007-05-01 : 03:59:33
|
| Hello,I have a complex query that returns a few thousand rows in around 15 seconds to .NET, which I am happy about, however I now need to return a second table that relates to the first table, but I don't want to rerun the first query. A Temporary table would do the job, ie run main query into temporary table, return temporary table, then do a join on temporary table with the child table, and return that. Is there a better solution?Thanks,Jon |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Parent and Child tables - parent complex