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

...

Sounds like parameter sniffing. Please post the code for your stored procedure.

Mitch2007 (7/24/2009)

---

Good day all,

trying to track down why this simple CASE...

Should have also noted that the table in my query has 1,000,000 records as well.

Lowell (7/24/2009)

---

isn't Crystal still client-server based, so you have to install Crystal on every machine that will run a report, vs SSRS which is a web server HTML based reporting...

All my kids love to read. My middle daughter wants to be an author. She prefers fiction (sci/fi, fantasy) over non-fiction.