quote:

---

1. A temp table matching your spec is created, with a number from 1 to 25, and a question.

2. I...

quote:

---

Thanks Jonathan.

Does that mean that the backup, when restored (with recovery), is a snapshot in time at the instant the backup job...

This changed between versions 6 and 7. The method was changed to a "fuzzy" backup where there is no "snapshot" synchonization but instead extents are backed up serially and...

quote:

---

I think you can't.

---

I know you can't.

--Jonathan

Use TOP 1 with your query as a derived table:

SELECT TOP 1 MaxStep, CaseNum, StepEndDt

FROM

(SELECT max(StepNum) AS MaxStep, CaseNum, StepEndDt

 FROM Loan_Step

 WHERE CaseNum = '200668'

...

quote:

---

After saying or supporting all of this, how can you now say that SQL Server would be doing the grouping and aggregation?...

quote:

---

While Schiller is certainly a class of its own, Dilbert is more intuitive to the majority of people.

October 31, 2003 at 4:27 pm

#480545