Posted by Steven Stern on 03/06/06 05:01

On Sat, 04 Mar 2006 11:01:08 -0800, BarrySDCA wrote:

> It's exactly what I'm doing.....I'm recording hits to an advertising
> engine, before they get to the media server. Some client players hit
> more than once before they connect, causing a duplicate entry. I just
> want to see it sorted out w/out the duplicates. I have the
> distribution server logs for accurate playback reporting, I'm only
> interested in seeing cleaned up hits.
>

If everything is the same except the timestamp, you can round that up to
the nearest second and use a SELECT DISTINCT.

Check your SQL server's date conversion options to find out how to get
different values from the timestamp field.

[Back to original message]