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

Agreed.  I don't know why 3rd part vendors do that to us.   In those cases, though, I'll still do bulk processing to fill a staging...

Diagnostic Manager... Now THAT's useful and I understand what you mean, now!  That kind of monitoring tool can be priceless!  Thanks for the info, Colin.

If it's a gotta-have-it now type of thing, look at the proc and see if it uses GETDATE() to update any columns in tables... you might have to do a...