Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To Do A Cross Tab
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01520803
Message ID:
01520880
Vues:
39
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform