Hi Michael,

Can you exec 100000 INSERT/UPDATE with external data ( not in SQL Tables )
with sp ?

No.

Even if it was possible,

Can you uses sp for do this operation on 100000 tables with one fixed schema ?
Possible solutions:
1 sp with 100000 IF ( slow )
2 sp build sqlString and EXEC this ( slow )
3 build one builder that build 100000 sp ( possible )

Fabio

RAD it obsolete,
RAM (Rapid Application Modification) it need.