Ok, now I have found something in BOL that seems to imply PK's are clustered, at least that's what I think its telling...

So I gotta ask, since performance tuning is not one of my strong suits, in fact, I don't even really have that suit at all, what are some ways to...

So does that mean it worked for you?

Took out my comment. It was a joke, but could easily have been misconstrued as bad advice.

Not tested, but I think this will work. You might want to put a trigger on one of the fields that are required to be updated in order to...

Learning Tree has a pretty comprehensive schedule of SQL classes. My company sent me to two of them, and I found the instructors to be very knowledgable and helpful....

Try this. The RTRIM is in there only because the species field is CHAR. You could omit it if you changed species to VARCHAR. Anyhow, just create...

I think this fixes your original question, which was the CASE in the WHERE clause.

select distinct

pl1.locationId as FromId,

...

Thats a good...

Ok, without having any more input, I got bored at work, and saw in this a good opportunity to try my limited skills. As always, the caveats are many,...

trk225, can you tell me *exactly* which characters you are trying to replace? XML is greek to me, so I don't know what you are trying to do.

SELECT DATENAME(dw,YourDate). Look up DATENAME and DATEPART in BOL.

Sounds like my company. We have so many people who absolutely refuse to make all our jobs easier by using the great tools we've been given, like a database.

Rodney

You can open your table in enterprize manager, make your changes, but instead of hitting the save button, there is another button that looks like a scroll, that will show...

Ron, I'm not sure exactly what you are looking for, but based on the four queries you provided, and I fixed the last one based on my assumptions, you get...

select...