Thanks for the info. Now I have a coding question

I have a 2 queries each with around 10 paramaters. The second query shares about 8 ofthese parameters with the other 2 changing. Currently after the first query I am doing
VB Code:
  1. sqlCmd.Parameters.Clear()
and then adding them all back in (with the 2 different ones) again. Is there a way of clearing just the 2 parameters and kepping the others.

Thanks