>To find duplicates by address:
>
>select PrimaryKey, Address, count(*) as MyCount from MyTable group by Address
>
>If MyCount is > 1... duplicates. To add the condition on dates, write a UDF that returns the number of the week from
>a date (based on your conditions) and select a new column beased on this new UDF and add this column to the GROUP BY clause.
>
>Vlad
How about WEEK()?
Erik Moore
Clientelligence