Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Do A Cross Tab
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01520803
Message ID:
01520880
Views:
38
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform