try this:

begin tran

Update Parent

Set ParentMaxDate = ISNull((Select Max(ChildDate) from Child where Child.FKParentID = Parent.ParentID),Null),

ParentMinDate = ISNULL((Select Min(ChildDate) from Child where Child.FKParentID = Parent.ParentID),NULL)

At my previous job, among many other things, I was responsible for creating reports. I learned early on that what people asked for wasn't really what they wanted. ...

Thanks for the additional information. Posting your sql statement was helpful.

Best regards,

Doug

Sorry to resurrect this topic however I’d like to ask a follow-up question. I need to copy a database to another database on the same server (MSSQL 7) also;...

That did it, thank you so much!

Doug

quote:

---

I think instead of doing a max() function in your "not exists" function you need to...