Reoccuring advertisement SQL Query

I'm having a hard time with this one, we're running Sms 2007. We have quite
a few advertisements out there.

I need to write a T-SQL query to identify reoccurring advertisements, in
particular, I'm trying to identity daily advertisements.

Any and all assistance appreciated,

Tony