× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



>> update pricefile set unit_price = unit_price * 1.05
>>    where product_type = "widgets"

>I've seen this example in so many SQL references as to make me ill.  This
is
>a very rare occurence for every business I've seen.  The people who decide
>what the prices are usually review sales and inventory figures on a case by
>case basis, then decide to raise or lower their prices based on past
>performance and seasonality factors.  In most cases, a list of new prices
is
>agreed upon in advance, and then these prices are applied,

>an item at a time.


It depends what you mean by "item".

When I worked for a retail apparel company I found that most of the business
was style driven.  A style of blouse might encompass five colors and six
sizes.  Prices were maintained at the style/color/size/store level (for us,
around 150 stores).  Price review or markdown of an "item" might impact
thousands of records.  Also temporary and permanent pricing was changed on a
weekly basis.  The example that makes you ill would have happened many times
each day, though the WHERE clause might be applied to style, style/color,
style/store, or style/color/store.

Of course we were running a traditional RPG-based package.  The updates
occurred in processing loops (or matching records routines!)

There's more to the example in any case.  There are pre-edit reports,
approval phases, audit logs, and POS price change transactions which would
all have to be translated to SQL.

-Jim

James Damato
Manager - Technical Administration
Dollar General Corporation
<mailto:jdamato@dollargeneral.com>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.