I had a job interview once where I was asked if I had ever thrown large manuals at people. I thought it was a joke question until it...

Wouldn't it be nice if competence were the sole criterion?

I'll apologize for the title then. I made it deliberately provocative to try to get some comments, so I'll take responsibility for people not realizing that what I...

Jeff, here is the code I used to test my results against the existing code, modified to prevent negative results. Let me know how it works for you.

-----------------------------...

Just out of curiousity, I reformatted that to make sense of the nested Case statements. They make sure that you never get a date below zero. ...

Thanks, Jeff. I was feeling the same frustration I used to feel in arguments with my first wife when she would tell me what my opinion was...

Don't you know? That isn't a sarcastic question, I promise. I just thought you were asking how to easily calculate elapsed time for a six-day work...

I have this sudden vision of a man in a Gestapo uniform staring at a PeopleSoft screen and thinking "We have ways of dealing with you."

Yet the poster apparently has more control than you would think 😉

Gail and Jeff,

That's a shame, but it's a function of this environment. Anyone can say anything they want as long as they don't get profane. ...

Thanks, tw. I'll look forward to hearing about it.

Thanks, Jeff:

The thing I find really odd about all this is that I don't think there should be an official blacklist either. If I felt that way, then...

Will you accept a blessing then, Lynn? You've got one whether you will or not.

You can tell that from the table and column names, I suppose.

Jacek0 is right. There is no performance advantage to a given maximum length for varchar columns. In fact, for very short columns the overhead of using varchar...