Comparing Weeks

[Guest]

Hi there,

I have a table, for example:

SONG WEEK
Song A 21
Song A 17
Song B 13
Song C 12
Song C 19

Ok. Let me try and explain what I need, and if possible the fastest solution
to this.
I have a table which "grabs" the songs played on a local radio station.
These songs are then stored in a database.

As it is right now, at the end of the week the program runs a procedure(on
thursdays, at 11pm) which sends me the list of songs for the current week.
After that, it deletes all the songs. And starts grabbing them start 12:01am
friday.

What I would like, since the station plays the same song for a couple weeks
straight sometimes..to not send me the song if it "occurs" in another week.

for instance, in the above table ..only Song B would be standing. Since both
A and B have been played during two different weeks.

thanks.
-State

 

[Guest]

Nevermind.
After some more messing around, i found that querying the data for which
song, which week..and then querying that for the count of weeks worked best.

Cheers
-State