Thanks for the reply. I'm putting my bets on blocking...

I am reading about using SQL Trace. I see "Lock: Timeout (timeout > 0)" as a candidate to trace. Does that...

Your example also demonstrates that the fields hold their original values. Thanks. I just didn't know if this is something, which SQL guarantees or is implementation-dependent.

If all field values contain their original value (i.e., before the update), then that's exactly what I wanted to know. This is the guarantee I was looking for. Thank you!

Thanks to all of you for your advice. I'll follow up as soon as possible...

Jamie

The rows are already available in a table variable, so the issue is not the time to gather them.

You are right that SELECT INTO is normally very fast. And the...

Thanks, guys.

The reason I asked is because the table in question is very large (about 1,000,000 records). Using SELECT INTO takes a couple of minutes to complete and creates so...

Lynn Pettis (5/9/2009)

---

Jamie,

You do understand that it isn't the implicit or explicit transaction itself that creates the locks, but the action itself (INSERT,UPDATE,DELETE, and even SELECT), and that any locks...

Hi all,

Thanks again to all who contributed to this post. As the OP (I'm assuming that means me, although I don't know what it stands for (original poster?)), let me...

Paul White (5/8/2009)

---

Jamie Julius (5/7/2009)

---

It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode of "Read committed"....

Bob Hovious (5/7/2009)

---

That is incorrect. Look at this. You can start a transaction explicity and leave it hanging in session 1, then go to session...

I didn't mention the datetime stuff in the original post, because I wanted to simplify the question. Please note that the crux of the question is about concurrency. I appreciate...

And then I guess I would need to handle the specific "duplicate" error as a non-error.

Thanks. I'm familiar with Books Online. It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode of...

Steve Jones - Editor (5/6/2009)

---

It doesn't always return 1. If you were to collide on concurrency, both insert a Userid = 1, then you'd get 2, then you'd know there's...

Thanks to all of you who looked into my question!

I gather that the consensus is to combine everything into a single statement like this:

insert into dbo.UserStats

select