Let me see if I can respond to both of the suggestions. Regarding turning identity on and off, is that session specific or table specific? If session specific then that...

Temp tables with identity columns as suggested seem to be the easiest way for us to get going with this. We are going to give it a try and see...

My vision is quite clouded these days. For good or otherwise I am loading records into a work table we use for printing reports and doing other processing. Our performance...

We cannot use identity because the table we are using is also processed by some program content that we have and the program content assigns the sequence number programmatically. I...