Spot on... I absolutely agree with Aaron.  In fact, I don't know of any other way to establish DRI between two different databases.

Cool... got titles and synops for the new books that you might care to share... nothing like being on the "bleeding edge", ya know

John,

Just one more question... is the CDRFingerPrint unique no matter how many CDR's you load?

John,

Despite the fact that Joe has, once again, demonstrated that soft-skills are not his main focus in life , he is absolutely correct......

Tom,

I agree with Serqiy... write other sp's to do one part of your process well... write as many as you need... then, go ahead and call them from a "main"......

The following (code) tells me that your clustered index on Termination_Date isn't covering enough of the columns... if it is, then why are you joining to EventType and CDRFingerPrint, as well? ...

Ok, not a problem (hopefully I understand your problem now)...

You'd lookup the timezone for each user, get the offset in minutes and, using DATEADD, simply add the minutes to the...

I agree... breaking up a proc/script just to control size is a bit stupid but using GOTO, as you suggested, isn't the way to do it.  CASE and IF BEGIN/END is...

I know that, John... what are the statements?  You may not need the loop at all!  Loops are a form of RBAR and generally defeat the power of an RDBMS!

I suspect that part of the reason that it's taking so long is because of the self join during the insert... the criteria may have to be reevaluated after every...

"doesn't seem to lend itself to any sort of structure"???

As Serqiy said, you can create stored procedures that act as "main" routines that call other sometimes reuseable stored procedures as if they...

{insert theme song from Jeopordy here}

Get 'em Serqiy!

John,

What format is the p.Termination_Date column in?  Because it's a CDR, I'm thinking it's probably in the YYMMDD format but want to find out for sure before I spend any...