Common table expressions provide a neat way of doing this...

WITH table1 as

(Select OrderNbr, max(UpdateDate) as UpdateDate FROM Orders

Group by OrderNbr)

SELECT * from table1

OK - thanks anyway. I guess I'll try that when I get the time.

Any update on this? I am having the same problem.

Hi J Gravelle,

I had a similar solution involving 2 functions - 1 to work out when the next working day is (including the current date) and 1 to apply this...

Thanks - this whole series has really helped my understanding of how useful XML can be, and how to use it in applications.

thanks - given me lots of ideas where this could be useful.