mosl31 (7/26/2009)

---

Not to be a nit-picker Lynn, but Brad did specifically refer to religion.

"People of faith, participating in their chosen religion."

For many people you can't have one without the other,...

Slick84 (7/26/2009)

---

So how about a DBA who does not possess those qualities and does not qualify the criteria you have laid out? What's wrong with them? If I'm reading your...

mosl31 (7/26/2009)

---

I would agree with all except the last one. I don't think DBA's are more religious than anyone else. Probably they are more like a typical scientist who is...

What is the performance of your...

Jeff Moden (7/24/2009)

---

Lynn Pettis (7/24/2009)

---

.,.,., why not let Jeff post the url? Others, like myself, may just benefit ... oh, you want to keep us in the dark, like...

Don't see why not. I'm using the 32-bit version of SSMS for SQL Server 2005 to manage x64 installations of SQL Server 2005. Should be the same with...

FYI, it looks like there is a newer version out: 4.1.5.0.

homebrew01 (7/24/2009)

---

Keep in mind that you cannot restore from 2005 back to 2000. I know it wasn't part of your question but might be relevant to whatever else you are...

Trooper (7/24/2009)

---

If anybody is in a similar situation , this might help....

I contacted Hyperbac and as Lynn said they got back to me in no time. All I had to...

Jack Corbett (7/24/2009)

---

Huh, I didn't know that "ColumnName = " was deprecated. I know people who really prefer that method. I NEVER use it, I ALWAYS use the...

Jack Corbett (7/24/2009)

---

Either of these should work, depends on your preference for placement of aliases:

SELECT

MyField02= CASE

WHEN (Right(MyField,2)*1)=7 THEN '999'

WHEN (Right(MyField,2)*1)7 THEN '888'

ELSE NULL

END

FROM

MyTable

SELECT

CASE

WHEN (Right(MyField,2)*1)=7 THEN '999'...

Jan Van der Eecken (7/24/2009)

---

Briefly away from literature... Went to collect some takeaway pizza at the beach front just now. On the way home there was a silver Audi A4...

How about provided the DDL for the table, sample data for the table (in a readily consummable format that can be cut/paste/run), and expected results based on the sample data....

My concerns regard both is the possibility of extraneous data returned based on the joins.

True. If that is the case, then we need this:

SELECT

CASE WHEN (Right(MyField,2)*1) = 7

...