I wasn't too impressed either, but...

Run this: select @ @version -- no space between the @ signs.

If it something like this: Microsoft SQL Server 2005 - 9.00.3080.00 (Intel X86) Sep ...

And another one, http://www.724hosting.com/sharepoint/SPpackages.htm?mainMenuItemToSlide=3.

Here is another SharePoint hosting provider, http://www.sharepointhostingspace.com/sharepoint-hosting-pricing.htm.

I'll do some research this evening while my daughter is at AWANA's.

Do we have the email addresses for the group yet?

Stefan_G (4/21/2010)

---

OK, I have now made some tests on both 2005 and 2008.

Exact versions:

Microsoft SQL Server 2008 (SP1) - 10.0.2757.0 (X64) Jan 8 2010 19:55:08 ...

I helped get SharePoint started here at work, but once it started taking off, I sort of fell out of the loop mostly. I know enough to be dangerous....

Steve Jones - Editor (4/21/2010)

---

I have spoken with my boss, and in principle he thinks it's a good idea to help out here. Any preferences on what you're like in...

In the last code snippet you posted, the first statement works in both SQL Server 2005 and SQL Server 2008 on my servers. The second fails just as it...

Stefan_G (4/21/2010)

---

I know...

And by the way, the following code in SQL Server 2005 behaves the same way the code above works in SQL Server 2008.

begin try

SELECT CASE WHEN 0=0 THEN getdate() ELSE...

Is rownum a declared column in your table?

Stefan_G (4/21/2010)

---

Lynn Pettis (4/21/2010)

---

I think you are missing the point. If it is a bug, it isn't a bug in how CASE works, it's a bug in how the...

Toby White (4/21/2010)

---

What system, application, and/or users DO need to see the salary data? If you rely on the SQL engine to decrypt the data, then you cannot avoid sysadmin...

jordon.shaw (4/21/2010)

---

I'm doing a query and I should know how I do this, but I just can't think of it right now. So, I'm query a table and the...