Simply put...

I have 1 table with an identity column.

Everytime that is incremented I need a second table's id column incremented also. I can make the second table's columnn an identity...

This did not work. The 6 was inserted intot he first table but not the second.

-Kevin

Here is what I have so far....

I have 2 versions (a cursor and stand alone sql's).

Note: the second part of this is to compare the last table they sent...