Michaell (3/5/2008)

---

Would it be the time itself is pretty much an unique value already?
So it don't produce a good index on it?

-------------------------
--------------------------
WHERE
filter 1
AND filter 2
AND CONVERT(DATETIME,A.DateValue) BETWEEN (GetDate()-30) AND (GetDate()+30)

select max(a.closedate) as closedate, a.offerid
from a inner join b on a.id =b.id
inner join c on b.xx = c.xx
group by a.offerid

Rishi Girdhar (3/6/2008)

---

Many times we need to use function 'MAX' in 'Select' clause specially for dates. Does anyone has a thought on different approach.

For example


Thanks,

Rishi