Sounds like you did your homework... glad it worked out.

Here's a simple one... the only problem with it is if a table name straddles an 8 k boundry... then it will miss the table name...

--Find name of...

What do you mean when you say it "timed out"?  What app are you in?

Thanks Serqiy.  Nope, I haven't actually lost my mind (yet).  I think just about everyone except the guy who wrote that knows that creating indexes on bit columns is a...

I dunno wth he found but I kinda like the looks of the calculated column... could be sargeble that way...

I'm a bit confused... are you trying to import the file (your comment about Bulk Insert) or are you trying to export to a text file and have the date...

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...