What I am trying to do is insert around 2000 rows of data from Table A into Table B and Table C. Table C needs the Identity value from Table B and I can't figure out the best way to do this.
So some data from Table A is inserted into Table B, the identity field from Table B then needs to tied to the phone number in Table A and both need to be inserted into Table C
[PhoneNumber] <-- Number from here
[AssID] <-- Identity (PK)
[TelNumber] <-- Number to here
[AssID] <-- To here (FK)
Hopefully this makes sense