Since I have a great text editor at hand I partially fixed your data. I wasn't sure which table the data was for, so you will need to fix...

You mean that some of the people are actually wearing kilts today?? Boy, I...

Indexed Views aren't necessarily the answer. ...

Could you post the full query you are using? There may be a better way do accomplish the task.

You do realize that he was not posting the entire proc, right?

Am I reading your post correctly? You are using the sa account to access your database from a web server?

We are currently running SQL Server 2005 EE on our production servers. We use HyperBac to compress our backups on the fly and our backups and restores are faste...

Direct from BOL (Books Online, the SL Server Help System):

READUNCOMMITTED

Specifies that dirty reads are allowed. No shared locks are issued to prevent other transactions from modifying data read by...

Glad to here things are working now.

If the database is using the SIMPLE recovery model and you have no backups, I'm sorry to say that you aren't going to be able to recover the lost data.

You...

jritson (11/4/2009)

---

It's not working because you're including the score which can differ. Think about your groupings as concatenations so 80Mike is different to 90Mike. What you need is exactly one...

It would help if you could provide the DDL (CREATE TABLE statements) for the tables, sample data (INSERT INTO <tablename> SELECT <values> UNION ALL ... ), expected results based on...

We have SCOM where I work but I haven't had the opportunity to work with our network admins in seeing how we could use it for monitoring SQL Server. ...

I think that has been suggested.

Understand, but I thought you...