Unanswered: Need delay in my bulk insert statement
I am working on a bulk insert statement. The stupid primary key, though, uses the Unix Epoch.. which means that I need some sort of "Delay" in my statement, so that each row will have a unique primary key.
If I read this right, the primary key is based on a datetime field (probably based on getdate()). If so, you are going to be a lot better off using either a GUID column, or an identity column for exactly the reasons you have just discovered. If this can not be done, then you will have to give up the bulk insert idea, because it is too fast. You will have to gin up some VB script to get the records in with enough delay (3 ms) between records.