Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select and set to variable
Message
De
08/03/2015 06:50:50
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01616353
Message ID:
01616437
Vues:
26
>We had one client who pretty creatively fought the system. Reputedly mobbed up. They set up trailers in the parking lot as "slot locations" and parked bogus inventory there. But they got caught.

OTOH that's exactly what I recommended, for a different purpose. They wanted to know the results of classing the eggs, so I told them to invent a virtual location called "classing", move unclassed eggs into it, then move out classed eggs (which were about five different SKUs). The number of eggs should fit, the difference in value should tell whether the quality was above or below average.

The idea didn't quite take, not immediately. It did gloriously, two weeks later, when their boss came to me with that scheme, presenting it as his own idea. I could only congratulate his ingeniousness... because 1) I didn't have to do anything, 2) if I didn't, I'd have to invent something else.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform