Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select and set to variable
Message
From
08/03/2015 06:50:50
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01616353
Message ID:
01616437
Views:
27
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform