Good lord, don't use a text column.  If you have to, put a VARCHAR(8000) in a parallel table with the same key...  you're asking for a world of hurt when...

Actually, it does... but you must include the object owner as the object name... in other words, you have to use the 2 part naming convention when changing the ownership...

Thanks for the feedback on this, Doanthi...

I don't know what it is but I've never had the speed problems with "Select Into" that so many have spoken about.  It is...

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