>>That's getting on my nerves :(
>>
>>Error: 1103
>>LineNo: 1228
>>Message: Invalid seek offset.
>>Procedure: runprocess
>>Details:
>>StackLevel: 2
>>LineContents: insert into load_trans_diagnosis_codes... Time spent: 43 sec.
>>
>>I added cEntered_User in all my insert statements, BTW.
>>
>>Ok, time to get another fresh set of data and re-try.
>
>I'd recreate my table and indexes when I get that error.
>I don't have an idea about cEntered_user.
>Cetin
I don't think re-creating it possible. However, right now I'm copying last night backup data to my local drive. Once it's done, I'll apply recent database changes, Reindex, Repair (all through SDT), then resume my tests.
cEntered_User is the field with GetUserID() as default value. I added it explicitly to all my insert commands, so it would not be calculated. Thanks again for this great idea which I'm sure would speed up this process a lot. ValidateSSN and age calculation parts were also updated since yesterday, but here I don't expect to gain very much.
I haven't switched back to scatter approach suggested by John Koziol since I already took time re-writing that code and converting to insert fields...
If it's not broken, fix it until it is.
My Blog