>I'm being stupid. I can use a parameterized procedure... just pass it the actual data.... So I don't have to create a new procedure each time. I may not be an expert with TSQL now. (I've not been doing it very long.) But I will be ...
except that according to the documentation -- SQLEXEC does not return the value return by sQl statement. It returns -1 for connect error , 0 if it is still executing, and 1 if successful. I'm still writing a procedure that returns @@rowcount, just in case the documentations is wrong (as sometimes happens with Microsoft.._
Thanks
Gar W. Lipow