>It works fine for me. If you just do
>
>select *, DENSE_RANK() over (partition by MailCounty order by Precinct) as Rn
>from tblCamp_CT
>
>Do you see the same number for BERNE B ? If not, it means there are some invisible characters in that field that make the entries non-unique.
THere are 695,223 rows returned. None distinct that I can see.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people