Flagging duplicate records (again)

Hi to all and thanks for the replys, but i'm still having a problem. What i
need to do is set dupe = 1 for all records where the phone call (by date) is
less than 30 days from the previous one (having the same phone number). For
example:
call_date phone_no dupe
2005-08-30 13:39:00 888-888-8888 0
2005-08-30 13:41:00 888-888-8888 1
2005-12-12 15:23:00 888-888-8888 0
2005-12-15 07:54:00 888-888-8888 1
Thanks to all in advance. It seems easy but i can't seem to figure it outThe first time you posted this question you haven't provided DDL and sample
data, and you weren't happy with the answers. Are you going for a second tim
e?
Maybe you should read this (if you haven't already):
http://www.aspfaq.com/etiquette.asp?id=5006
ML
http://milambda.blogspot.com/