Because it's just as easy to make a parallel table and still enjoy all of the benefits of the various string functions (if you need them, someday) that you can use...

Very nice, Joe... when do they hit the streets?

Eric, your current code misses an overlay... see line 8 below...

First of all, let's draw a picture of everything that has a start date less than the end date and...

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