You could try simply dropping the TotalCleared from #temp. It is not needed. The update you are doing to that column will always contain just the rowcount. I assume you...

Bill Coale (3/13/2008)

---

For this date range technique, for the end date:

nextrow.PriceStartDate AS EndDate

I usually do:

dateadd(day, -1, nextrow.PriceStartDate) AS EndDate

Also truncate to midnight the start/end date and any date comparisons...

Tao Klerks (11/18/2008)

---

Hi slange,

I think you're confusing a couple of possibilities.

The query above reports employees who have no "subordinates" - there are no employees that have their employeeid in the...

Tao Klerks (11/18/2008)

---

Hmm, nice one, I've never seen that issue described.

That provides another reason why the following syntax is (in my opinion) preferable:

select *

from employees

left join employees as...

I fell victim to a similair script at one point. :Whistling: As a result I now make it my standard habit that after the declaration of the sp i wrap...