Both. They do different things. Where they overlap in function, either will work.

True. After all, what's politics got to do with karate?

Nope. Implicit conversion can be a problem on just about any data...

Matt's already tested that on a prior thread. A...

They have a tendency to be badly misused, much like cursors, UDFs, et al.

I've seen lots of views that included six or seven tables, dozens of...

Chris: Yes, SQL 2000 needed Goto for exactly that. You're right.

Tom: I haven't found a need for that. I can see where it might have a use, but...

I have to agree with the article, with Phil, and with Grant, all at the same time. (My sig pretty clearly sums up why I say that.)

I have run...

I just ran my unmodified code on my machine, and got Jan 31, Feb 29 and Mar 31.

The difference is probably where your Numbers table starts. Mine starts at...

Most of what I do uses derived tables as well. Actually, I use CTEs for those these days, but it's the same concept.

My point is merely that temp tables...

On CLR, yes, it will be faster than the CTE on that.

I actually don't know if you can do an in-place installation, since Dev Edition isn't supposed to be used for production databases.

On the other hand, you'll need your server settings,...

rbarryyoung (8/11/2008)

---

Yeah, I knew that Gus. Sorry if it looked like I was responding to you, I...

Steve Jones - Editor (8/11/2008)

---

GSqaured,

Sorry to hear that and hope you have some great memories. I know as I get older, things hurt, it becomes harder and harder to stress...

Jimbo (8/11/2008)

---

GSquared:

I can sympathize. We do what we can with what we have. When I walk the dog, I often still get an annoying shin splint feeling in...

On the subject of marketing and preconceptions, I've actually seen several hundred people do "the Pepsi Challenge", with both cups filled with Coke, and most people had strong preferences for...