scking,

I'm curious... what is your objection to using ISNULL or it's big brother, COALESCE?  Yes, CASE works but it's probably not a fast as ISNULL...  your last CASE example could...

Miller Time,

Don't define the new column as a TimeStamp datatype... the TimeStamp data type in MS-SQL Server is actually a binary number used for row versioning and has nothing to...

Do you want the time included in the default, or not?  All of the posts, so far, include time.

That's a pretty good two cents... lot's of folks forget that there IS a difference between 90 days and 3 months.

JN, here's the code without the time stripping part... that's...

Don't forget that just subtracting 90 days using either method will not take you to midnight of the given day... the current time element will be included unless you do...

This'll work if you have a DBA that doesn't understand the merits of a date table and it's short enough to use in inline code if the...

Hopefully, SP4 will fix some of the memory leaks.  It came out this last Friday.

The problem in our shop used to be that no-one did a code review of other's...

I second Carl's suggestion about turning AutoShrink off... AutoShrink causes several problems not the least of which can be severe disk fragmentation and long wait times when it does need...

I don't believe I'd use a trigger for this because if the Oracle DB or the connection to it is down, then your SQL Server...

I don't believe I'd use a trigger for this because if the Oracle DB or the connection to it is down, then your SQL Server processes will start kicking off...

I believe that it's called an "M-Space" and occupies the same width as the letter 'M", hence the name.  Since it's not a regular space character (ASCII 32), you may...

Here's a couple of other differences...

PRINT doesn't print those pesky column headers.

PRINT outputs to the MESSAGES tab even if the GRID mode is turned on.  SELECT will print to the...

Ok, so you've shown what doesn't work... what, in your estimation, would work if you were given that particular problem (the Adam Mechanic one) with that particular data?

Michelle/Dolphin,

Thanks for the feedback on the medical community... I guess that's one place where the following saying (author unknown) applies...

"Normalize 'till it hurts,

DeNormalize 'till it works."

>The proprietary syntax has unpredictable results.

Only in something other than the SQL it was written in.  It is not upredictable in SQL Server. 

>Notice that we did not use the...