Great code one and all.  I've got a slightly different idea and it's pretty flexible for making other reports, as well.  It also includes columnar and row totals as well...

Nicely done... I'm just a bit squemish about relying on what the default datetime formats have been set to... also, if you replace @String with a column name in the...

Why do you have trailing spaces and what is it that you're trying to do?  Are you trying to find entries that have trailing spaces to eliminate the trailing spaces...

Obviously, I've not tested this... but it should work...

 UPDATE u1

    SET InstantASP_UserID = u2.UserID

   FROM MyDB1.dbo.Users u1,

        MyDB2.dbo.InstantASP_Users u2,

        dbo.aspnet_Membership a

  WHERE a.UserId = u1.UserID

    AND u2.EmailAddress...

Having been in the telecommunications world for about 11 years, lemme just say...

DON'T COMBINE THE NPA AND NXX COLUMNS!!!!!!!!  You will hate yourself so bad in the future for more...

Stop looking at tables for this... use the built in functions...

IF OBJECT_ID('databasename.ownername.objectname') IS NOT NULL

DROP objecttype ownername.objectname

Are you using the ENTERPRISE edition of SQL Server?  If not, you must be using the STANDARD edition and that would be the reason why...

Deadlocks ARE "critical errors"!!!

Deadlocks are lost data (an excessive waits) and are a key measure to the health of an SQL based system.  Perhaps most companies have executives that are simply...

You bet, John... thank you kindly for the feedback.

Bill,

I'm well aware of NextID tables (sequence tables) and the methods to use them without causing a bottle-neck without any chance of a deadlock or extended wait even during the...

Oracle is case sensitive for table and column names and must be upper case during this type of transfer.  Put the quotes back in and modify the things in quotes...

What does the number of years have to do with the person count?

Moot point... the problem is that you are creating a "triangular join" with the "less than" condition... it's...

Better than that, why do you think you need a function at all?  *sniff* *sniff* I smell some RBAR coming up

This should do it for you... includes a test setup so you can "play"...

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

     IF OBJECT_ID('TempDB..#yourtable') IS NOT NULL

        DROP TABLE...

Nicely done, Michael. Real good to see someone actually do a comparison in performance, too.

Since you were kind enough to mention my name, I have to sing the praises of...