Thanks Koen,

I followed your link and used the steps there...

1. Restart SQL Server in single user mode

2. Start SSMS as administrator

3. Connect to SQL Server using object explorer

It worked. I...

I am using the only account I ever use on that test box, and it's the one I used when I installed the software. This box is not connected to...

Yes, the service is running. I restarted it to be sure, but it makes no difference. It is running under the

Local Network Service account.

The error message I get is...

I am happy to say I got this right, but not so sure about the reason!

I didn't know the answer (so learned something here, and that's good), but worked it...

David.Poole (1/11/2014)

---

I'm wondering if a natural development path for future developments of SQL Server will be as a general data management platform that can use relational, key-value, document and distributed...

Not yet....

sneumersky (1/8/2014)

---

It is important to note that:

SNOMED more facilitates information input into an electronic record during patient care (OLTP in concept)

Conversly, ICD facilitates data retrieval for purposes outside of patient...

teodorom (1/8/2014)

---

Hi Toni,

very interesting paper.

I could be that I could use these ideas in the near future (I hope !).

Since I would like to do some tests it would be...

Education, communication, understanding: they are all critical in resolving this issue.

My DBA background was initially as a developer in FoxPro where the code and the database are deeply connected. This...

Oops again.:w00t:This time I didn't even read the objective correctly! for some reason I thought it was just to set all values of Gender to 'M'. Apologies to the question...

I answered the wrong question.:crying: "Objective: Update all the M's to F and all F's to M. " and the result of statement 4 will not be that objective....

I have just found the solution (in a free Microsoft eBook "Microsoft_Press_ebook_Introducing_Microsoft_SQL_Server_2008_R2"#.:-#

To quote from the book... "The expression language in SQL Server 2008 R2 Reporting Services includes a new global...

Fair comment, and I appreciate what you are saying.

However, my point about your method also skewing the result still stands. The opinion of the single Business Studies tutor carries...

Mathematically speaking Jeff is correct - you can't take an average of averages and expect it to represent the true overall average (although it might!) - it all depends on...

Depending on what your data is like, I can think if a possible solution.

If your data is a string variable @string then

@string NOT LIKE 'Xyz'

could be replaced with ...

replace(@string,'Xyz','zzz')...