Doesn't get much sun, does he? Wait, except for about an inch or so on each side of my knees my legs are probably...

PSB (11/4/2009)

---

I have a query that is not accepting GETDATE() . But when I hardcode today's date then it works fine .

Below is a sample of my query

select Columnnames

from...

UltraEdit. I love the column mode. I can also do syntax highlighting in a variety of languages using it.

I actually use UltraEdit Studio, but UltraEdit is still at...

Cute! I think my kids would disown me if I wore one, especially in public. 😛

I guess i should...

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...