Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Search based on intersect
Message
De
17/01/2017 08:12:00
 
 
À
17/01/2017 08:05:30
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows Server 2012
Divers
Thread ID:
01646717
Message ID:
01646733
Vues:
25
>If you say so, but that is not the way I read it

I forgot to mention that the Member.Numero=1, last condition at the end of that select command, was to associate everything against one specific member. I also tried to create a scenario which differs a lot from the real select command I have, which is much more complex. So, at the same time, I tried to make the sample as small as possible.

It turned out that everything is working very well as is. On the first round of test, there was a factor that was not taken into consideration. But, after having looked more into it, that intersect is actually in deed bounced off the main result of the first and last name results. So, I could have 10 Member records found where either the first and last names match, but only 9 would be returned at the end based on the intersect.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform