xenophilia (4/4/2012)

---

Well, your very first query/response works and I was going to go with that (apply to real life situation), but I'll make sure to look at the others too....

your rownumber over will work and may be faster than my join to a sub query. i would try both in your system and use which every is faster.

patrickmcginnis59 (4/4/2012)

---

Here's my attempt, probably can be shortened or better versions posted by the experts.

select row, studentid, revision_cycle, grade_assigned, reason

from

(

select row_number() over (partition by studentid order by revision_cycle desc) row,

studentid,...

and how different can you get in 6 links?

i got to rolling stone

http://en.wikipedia.org/wiki/Rolling_Stone

sharky (4/4/2012)

---

SQL is pretty bad at doing any character manipulation and comparison. I always use LIKE, CHARINDEX etc. as a last resort. I agree, your solution performs much better...

Jack Corbett (4/4/2012)

---

Stefan Krzywicki (4/4/2012)

---

Ever worked with someone who can't seem to handle answering more than one question in an email? I'll ask several related questions and receive...

Cadavre (4/4/2012)

---

I know what you're thinking, it's far faster to not cast a datetime as a string so it follows that it'll...

joshd 1807 (4/4/2012)

---

I don't think I'd need to test for a valid date as the FedEx software would take care of that itself.

I'll give your suggestion a try and let...

GSquared (4/4/2012)

---

I get a...

i always like the ones that thank my post count level thingy (ssc-whatever)

Gianluca Sartori (4/4/2012)

---

You can cast both to DATE type:

SELECT CASE

WHEN CAST(@datetimefield AS DATE) = CAST(@dateonlyparameter AS DATE)

...

if you are writing a custom program or want to write triggers on a table we do something similar to this. we have a waiting assignment table. the...

davidandrews13 (4/4/2012)

---

ok. thats weird.

my example was totally made up to illustrate my point. Maybe, in making it up, i inadvertently made it less clear what was going on.

Here are my...

GilaMonster (4/4/2012)

---

Highly unlikely.

If it's running at a different time of the day it could be that the disk and network are under less load.

Backup and restore time are principally governed...

GilaMonster (4/4/2012)

---

The answer is grant view definition to that user. Why is that not an option here?

p.s. sysobjects is deprecated, should not be used any longer, included only for backward...