My DBA is the one who set it up so I'm not sure... but I'll find out...

Yep... you can do that... like you said though, the automagic century-cutoff should do the trick but even that can be wrong if these dates are DOB's.

The slashes were an...

Oh yeah... almost forgot... if you want to see the code the script above generates, just change the "EXEC" to a "PRINT". 

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