Congrats again on the half million. What has it done for me???

Let's just say that I wouldn't know anything in sql server if it were not for this site....

I'm still part of the audiance, and I think we should get another recall :).

As Steve said, use the datetime or whatever is usefull to recognize that file from a human standpoint, then use identity to insure uniqueness. Sometimes there are very simple...

Nothing wrong here Steve... maybe this is the thread I used to contact you about the subquery error.

We should have a best comeback constest... this one would start as a favorite :P.

I should have quoted his message... we would have a proof of something :P.

No we are not hearing voices in our head... That's what they tell me :hehe:.

What were you testing Jeff?

Halloween bug?

Where do you want to work... I might have something opened?

TSQL is only a tool. It is as good as the one using it.

My results on Express SP2

INSERT INTO jbmTest1 --(120 seconds)

(RowNum, SomeInt, SomeString, SomeCSV, SomeNumber, SomeDate)

SELECT RowNum, SomeInt, SomeString, SomeCSV, SomeNumber, SomeDate

FROM jbmTest

-- secs

--===== Insert Data 100% interleaved in clustered index

INSERT...

Doesn't work if there are more than 1 export in the same day. And I would plan for that possibility, regardless of the current situation and requirements.

Datetime has the...

Quoting myself : Sorry Tomm, I had missed your post. Your solution is much much workable than mine.

However, I too would like to see the whole test. Math operations...

I love it... this is why we need that many members here!

If I may add something. It is not wise to counter-guess the execution plans made by the optimizer. I know we sometimes get better results, but we don't...