Thanx for that, I have already done a function myself that splits my parameters, the problem is that for each set of parameters that I put into my query I need to know which parameters have produced which result.
Dan -----Original Message----- From: David L. Penton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 16:58 To: ActiveServerPages Subject: RE: Complex SQL/Stored Proc question Look here: http://www.davidpenton.com/testsite/scratch/ for my udf_split function. Then you can pass in a delimited list and join table to table. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Hi All, I have a Stored procedure that queries a SQL2k database for various items and returns a single ID for each result found. Now this work pretty well, taking about 400-500ms for each query. The problem is that I need to call this procedure up to 10 times in a go with different parameters so the time would go up to and over 5 seconds sometimes which is way to slow for what we are doing. I have tried passing all of the parameter in one go (Using a seperator and iterating through the list). If I query using a "union" or a temp table then the perfomance isnt realy any better, but if i do one query but use a large "OR" for the different parameters the perfomance is fine for what we want. The only problem with this is I need a way of matching up the original parameters with the results, I dont think this is going to be possible but anyone have any suggestions? Dan --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
