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 PROTECTED]
