If it were me, I'd search the Microsoft website for "certification" to get the info straight from the horse's mouth.

It may also be that the Customer table is actually some (synonym) view that someone changed or changed the underlying table on.  My recommendation is to do an execution plan...

The query does not make it's own deadlocks... the query is not wrong.  Take a look at Books Online... something else is wrong... it may be that someone added a...

Did you do a "search" in the "Search" box on this forum?  Look for "hierarchy" and "tree"... lot's of good posts on the subject...

Outstanding... you were correct from your other post in that...

1.  You would help others

2.  You could find it again.

I remember...

It's almost the same problem as this...

SELECT 'A'+1

You must convert the numeric variables to strings in order to concatenate them with other strings.

Look, also, for "triangular joins" especially in correlated sub-queries (which can be a RBAR load all by themselves).  An example of a "triangualar join" might be something like the classic...

Well, well, well... I wondered where I saw that lick of code before... Welcome aboard, Josh!

THAT is very true... there's a hot fix for it (although I don't remember the #, check the MS website).  In fact, if parallelism is spawned and you don't have...

Very nicely done and very neat idea, Harry... gotta couple of rhetorical questions and a tip or two...

1.  It would appear that ProcFinish and ProcFiledate will always have the same...

Ah... I get it.  The W3Schools website does have both "equi-joins" (joins in the WHERE Clause) and ANSI Joins (INNER JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER, CROSS, etc) with...

The real problem is that no matter what anyone does, you will not be able to differentiate between the two formats if both the day and month are <= 12. ...

I believe it's because some of the system owned spids are doing work in the background.  On a dead quiet system, SQL Server has a "heartbeat" that occurs about once...

Thanks for the feedback, Gabor.  Yep, I found the same thing and more... I'm not sure what I was thinking of before.  Must'a been some bad coffee of something...

Gabor, I admittedly need to do a little more research but considering that the "Reorganize data and index pages" option actually moves data from the end of the physical file to...