The dates being returned are not the correct dates. They are completely off... I have double checked using my old method, and looking directly in the database one record at...

I can run the query, and get results (which I am checking now for correctness) but I still get this message everytime I run it in the SQL management studio......

I just looked and I am in 90 compatibility mode.

Sorry, didnt realize this would be a SQL 2000 since I have 80 compatibility on...

And that is am awesome catch on the comma... I never would have found that.

Should I...

I do appreciate your help...

When running this query SQL 2005 gives this error.

Error in SELECT clause: expression near 'fl'.

The OVER SQL construct or statement is not supported.

Possibly something like that, but keep in mid the 2 statements return 2 different flagdates representing 2 different events... Looks like what you have there will only give me the...

FYI... All the joins I put together kept returning NULLS for the flagdates, when I know there is data there. That's why I didnt even include my attempts at the...