I think that I forgot to mention this.

I can write a query of the same thing that is in the sproc, and it works fine, inserts all rows.

This is driving me insane at this point.

Anyone else have any suggestions?

Thanks

Andrew SQLDBA