Results 1 to 4 of 4

Thread: One item with two prices or two expiry dates

  1. #1
    Join Date
    Nov 2009
    Posts
    1

    One item with two prices or two expiry dates

    I have a problem and I can't solve it.

    Its about designing a database with table where items are stored, but those items can be with more than one selling price - two and more, or those items can be with more than one expiring date.

    For example, one article once can come with 20 dollars price, 30 pieces. After some days, the same article can come with 30 dollars price, 10 pieces. BUT, the problem is that there are still articles for 20 dollars!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Maybe add a subid column to the table and enter them as different row with proper subid?

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Or maybe a id / quantity snowflake?

    A table with the unit id, a separate (snowflaked) table joined by that id, that contained the id paired with the distinct quantities / ranges , and the price on each distinct row of the snowflake.

    Just the kind of thing I would do to support OLAP, etc., but maybe of use to you here, as well.

    HTH,

    B*

  4. #4
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Any success?

    Were you able to get anywhere with meeting your requirement? Let us know if we can help further ...

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •