Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select and set to variable
Message
 
 
À
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:
01616439
Vues:
30
>>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.

That would have been entirely counter to our business purpose, which was to keep exact track of a warehouse inventory -- how much you had and where everything was. You wouldn't believe what a big problem that was in the grocery industry (or maybe you would). The primary benefit of the software was customers had a reduced need for workers in the warehouse (something I was always uncomfortable with). Forklift drivers didn't have to look around for reserve locations when the pick slot needed to be replenished, they had instructions where to go, and were directed to optimal slot locations when new stock came in from the vendors, instead of putting it in the first place that looked handy. I'm not saying they were dummies, because they sure weren't, but a half million square foot warehouse with thousands of SKUs is a more complicated place than you might expect. It was really an ideal use of computers. We sold it for upwards of a million dollars and the customers made that back pretty quickly..
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform