This should pass your Use Cases...

--=============================================================================

--      Setup for testing

--=============================================================================

--===== System presets

    SET NOCOUNT ON

--===== If the temporary test table exists, drop it

     IF OBJECT_ID('TempDB..#Customer') IS NOT...

WTH?  Why can't you use stored procedures or a UDF?  Yeah, I know... "Business Requirement".  WHAT is that business requirement?

Oh yeah... one other question... are you trying the latest code with the UPDATE/INSERT where there are no SELECTs?

I ran into something similar... if you drop and recreate a table, the views associated with that table must be recreated, as well.  Are you sure you didn't recreate the...

Cluster the IDENTITY column if you wish... the natural key you are inserting to should not be clustered for the very reason you mention.

On the ROWLOCK on the SELECT... go...

Why?  My last solution has no SELECT whatsoever...

I guess that's where I was going with that, David... I'm trying to stay away from the sub-query and it came out wrong.

If the ROWLOCK,HOLDLOCK works to keep the PK violations out, that'll work... I was peeling 1 potato at a time   How's the deadlock...

I'm trying to stay away from SELECT at all, Serqiy...

I stand corrected.  Thanks David.

Nice, but if you ever end up with 3 entries for a property, your method won't work.

But, this will...

 SELECT MAX(ID) AS...

Greg,

It would appear that your TimeIn column could have the following formats...

6:15 a.m.

12:15 p.m.

6:15 p.m.

12:15 a.m.

The periods in the "a.m." and "p.m." could make this a bugger to convert.  Even...

The way you indent on this forum is to use leading spaces or use the "Increase Indent" tool at the top of the message box when you are creating your...

Ok, Lisa... you just assumed that I knew you were talking about the "other" code in your rule of thumb and I thought you were talking about the code I submitted...

1. The order will almost always be determined externally to this expression anyway, since unless you can guarantee < 12 months and all in the same calendar year you might...