The app is for internal use only.  I was being limited to a total of 21 different selections using the sp_executeSQL method.  By changing to the exec() method I am...

Frank,

Thanks for the help.  I am going to use EXEC().  This allowed me to get the majority of the selections and is acceptable.  Thanks for the link.

Thanks, I will check that site out and let you know what the outcome is.

sfm,

I just had a similar question.  I tried the #Temp route but when I had to write in 17000 records to the temp table it cost me 4 seconds.  This...

Thanks wz700, I will try that.

I have explored the use of #Temp, doing an insert on that table takes about 4 secs. for about 11000 rows.  However, when I attempt to query up any data...