vstitte (1/26/2010)
Thats what Jason is asking.Do you want the date column in the result set? If yes, what do you want the output to look like?
If you exclude id and date, then it looks like the SQL you have should work.
Precisely. If you try to include the date column then you must also add it to the group by clause which will change your result set. However, if any date will work - then there are options available.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events