> > I tried using a work-around that involves a temp table, but it seems > > the temp table is going out of scope in my ASP page(ADODB access to > > MSSQL)... I'm guessing it might have something to do with some sort of > > connection pooling...
> Use MTS. <gd&r> Actually, I'm biting the bullet and re-writing the code for the ASP page into a stored procedure. It will give an overall performance boost. Having a minor issue I haven't looked into now with not being able to get the SP results through ADO, but I'm sure I'll be able to figure that one out... In Query Analyzer, the SP is very fast and does a lot more than the original query I posted here. -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
