Not sure if this is more efficient and you'd have to test, but you could join with an OR and then use a CASE statement.

Select

case

...

No idea. I'll have to ask.

You are right (as usual), Gail. I thought it would start in read-only mode, but sure enough I get a failure.

The problem is probably rights. Your system cannot open c:\xxx.mdf...

There should be information in the SQL Server error log about it starting. Look for that. tempdb being broken doesn't prevent the instance from starting.

jasona.work (7/5/2013)

---

Hmm, can we amend that to be:

We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable...

Hope everyone had a good Fourth. My day?

We leave late for the mountains (1), hit traffic (2), Tia's hungry, but everywhere in Idaho Springs is packed and busy (3). Hit...

I hate doing this in individual emails, since I think it's a poor design practice. Over time, or when things are busy, people get tons of emails that aren't necessary....

Lowell does it the way I'd do it if the data is static.

If it's not completely static, or may change often, then you could use another table.

create table status

( code...

What's in the error log?

swwg69 (7/4/2013)

---

As a father with daughters, I worry about the indiscriminate abuse by single FBI agents. Let me cross reference birth control pills with condom purchases and bar patronage....

Thomas Abraham (7/4/2013)

---

Thanks for the question Steve. However, in the spirit of harmonic international relations, I propose that we extend the same courtesy to other countries: August 1st for Switzerland,...

Perhaps at some point. It's sales...

you misspelled...

What about pre-submitting questions or scenarios to speakers a week in advance, giving them some idea of the parts of the topic you want to cover?

Jeff Moden (7/3/2013)

---

Steve Jones - SSC Editor (7/3/2013)

---

I'd argue these days we should have tools that reformat stuff for us. My company (Red Gate) makes one, but there are others.

We...