Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111

    Unanswered: A design and structure idea

    I send an image to explain the problem.

    If you can give an idea, I'll appreciate very much.

    Thank you.

    Ruas
    Attached Thumbnails Attached Thumbnails forum.gif  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    my idea:
    Code:
    create table stuff
    ( N           char(1) not null
    , L           char(1) not null
    , AmtRangeLo  currency not null 
    , AmtRangeHi  currency not null 
    , Amount      currency not null 
    , RedOrBlack  char(1)  not null
    )
    insert into stuff 
     values('1','A',0.00,1749.99,20.00,'B')
    insert into stuff 
     values('1','B',0.00,1749.99,30.00,'B')
    insert into stuff 
     values('1','C',0.00,1749.99, 3.02,'R')
    insert into stuff 
     values('1','D',0.00,1749.99,50.00,'R')
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111
    Thanks for the idea. Lots of work....

    In the meantime, let me tell: "0,00 a 1749,99" means: < 1749,99

    When N = 1 and Amount < 1749,99
    then
    the value of A is found in the first column under this Amount.

    Ruas

Posting Permissions

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