Stewart "Arturius" Campbell (2/3/2012)

---

Eric M Russell (2/3/2012)

---

I've worked on projects in the past where the business would provide Excel sheets for populating reference tables, and they would basically just create...

I've worked on projects in the past where the business would provide Excel sheets for populating reference tables, and they would basically just create and fill in the data in...

Mark Hill-285393 (2/2/2012)

---

I am in the habit of using COALESCE for such things, mainly because I also use MySql, which doesn't have ISNULL. But everyone should read the link...

Jeff Moden (2/1/2012)

---

Eric M Russell (2/1/2012)

---

tyson.price (2/1/2012)

---

I see what you...

subzzz_ (2/1/2012)

---

Sorry, my mistake.

It's a force of habit from talking...

tyson.price (2/1/2012)

---

I see what you are asking but as far...

There is no concept of a "cell" in SQL Server. Are you talking about SQL Server or Excel?

earnest.williams (1/26/2012)

---

I'm a student and a newbie with databases. I was wondering if anyone could provide me some information on constraints. What would the basic way to write...

Is a company's morale metrics visible only to employees or also to the general public? It sounds like a useful tool for someone evaluating job offers.

Coincidentally, while shaving and getting suited up this morning, I started thinking about the idea that we should not consider the time we put in at work as "time spent"...

Steve Jones - SSC Editor (1/24/2012)

---

Having attended lots of conferences, it seems that it's the exception rather than the rule that people are skipping sessions and taking a vacation. The...

TravisDBA (1/24/2012)

---

Eric M Russell (1/24/2012)

---

TravisDBA (1/24/2012)

---

My company sent four people (mostly managers) about three years ago to that and they ran up the company's expense accounts so bad on that...

TravisDBA (1/24/2012)

---

My company sent four people (mostly managers) about three years ago to that and they ran up the company's expense accounts so bad on that one trip, (not to...

I wish it were here in Atlanta.

When initially writing a block of SQL code, I often times jiggle it around a number of times until I get just the right join and optimal execution plan.