Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Eliminating WHERE clauses with NOT
Message
De
05/11/2014 08:08:38
John Baird
Coatesville, Pennsylvanie, États-Unis
 
 
À
05/11/2014 08:00:17
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Web
Divers
Thread ID:
01610458
Message ID:
01610519
Vues:
41
>>>>>Do you understand the above 2 select statements as they are written and can you provide examples / translate them into plain English logic? I prefer simple logic that I can understand from a quick glance inside my head.
>>>>
>>>>I have no problem reading that. Makes perfect sense. I was laughing because of your reply to Thomas as to whether you know if all conditions are covered in your answer. I would have expected nothing different.
>>>
>>>If you have no problem reading the statements as they are written then please translate them into English for me. See also if you can make the logic simpler to understand.
>>
>>
>>Nope... not doing your work for you.... sorry... but I have no problem with your answer either, as long as there are tests for all the conditions...
>
>As others already have proven (yes, I had only small hopes that Naomi would check up her own posting) the solution do not neccessarily give the same result sets.
>To offer a bit of code as replacement and then stating that one is not sure one understands the earlier code is, hmmm, well intentioned ( as in pavement of road to hell).
>Also I am pretty certain that you picked up the differences and ways to disprove while reading.
>
>Personal POV: Offering a full set of permutations of conditions as best way to follow up would not be the best idea / tip to give her, if she wanted to follow up herself - in my book that would be wasteful, as testing every contingency will make sure the project never finishes...
>
>Trying to get a visualization or transation is actually not a bad idea in many cases, while just finding one condition where results are different probably is the easiest way here, at least for the way my mind operates.

I agree. That's why I tend not to provide code samples to her. You can find them on Google just as easily, but the problem with Naomi and code samples is she'll try one and if that doesn't work or has errors, she'll try another, and another etc. I would hate to be hired to maintain that code base. With the angular JS stuff, she's in over her head.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform