Be careful about concatenating strings in a SELECT statement:

DECLARE @X varchar(2000) = ''

DECLARE @Y varchar(2000) = ''

DECLARE @T TABLE (I varchar(10), O varchar(10))

SET NOCOUNT ON

INSERT @T SELECT 1,'A'

INSERT @T...

I agree with many of the comments in this exchange, but I would like to put another word on the table - APTITUDE.

I appreciate a nice-looking house, but you could...

I think bad managers waste far more than their own salary.

I think training is fine, but it's applicable mostly to routine jobs. Many jobs in IT (and many jobs outside...

Do not miss this article...

http://www.forbes.com/sites/mikemyatt/2012/12/13/10-reasons-your-top-talent-will-leave-you/[/url]

Again, my original post was not intended to say that IM has no legitimate uses. Instead, I was commenting on two things in combination, one of them being IM and...

I guess I have never mastered the ability to overcome a seemingly natural human tendency to be self-conscious. It's a component of what makes humans different from animals and I'm...

Thanks for your comments.

The...

I have been in the work force for 30 years. I have observed family, friends, fellow employees, business contacts, and personal contacts in the work force for 30 years. It's...

I presume cheating has existed throughout history. However, I think the stakes are higher now than ever before with sports at all levels being a prime example. Further, I think...

Christian Buettner (8/22/2008)

---

Too often I have seen the loudest employees rise the ladder of success, and good employees doing their jobs silently stayed unrecognized.

While the loud employees give at...

I absolutely agree, and I said as much in my original post. However, as much as I love IT, I...

I appreciate the good comments, but my post was not intended to solicit résumé advice. I understand the different strategies for writing a résumé. However, the initial "read" of a...

The entry below was submitted about three hours after the challenge first appeared on the web site.  It uses the Scores table as the table was originally defined (instead of...

I'm having trouble trying to envision a legitimate reason for needing or wanting to copy encrypted stored procedures.