You should check on your server, but I'mm 99.9% sure it's all or nothing on a insert .. select if there's PK duplication or FK constraint violation of the rows in the select nothing will be inserted.

>Can you tell me if failure is "all or nothing"? In other words, if some row from the Select contains an illegal value, does the entire insert fail? I should be able to figure this out myself if I could ever get it to work <g>.