Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    202

    Unanswered: Need help on sql statement

    hi there,

    I got this one prob on sql statement.
    I need to identify data/record which have to be inside this requirement:

    1) field "DateLine" which is a date and stated 20040611
    2) A process last for 5 days and is divided into 2 groups(group A and B) which field A is the dateline for the process.
    3) Gruop A of the process must take 3 days to finish and the group B must take 2 days to finish.

    question: what is the sql statement which can identify which record are already late which explain a record that more than 3 days but still in group A and already more than 2 days but still in group B.

    So basically, the record must not more than 20040609 but stil in group A where it should be in group B already by 20040610.

    Can anyone help me with the sql statement?
    thanx

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...not without your table schema.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's an f'n homework assignment...I thought school was OUT....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by Brett Kaiser
    It's an f'n homework assignment...I thought school was OUT....
    You remember summer school, don't you? Sister Mary-Elephant standing up front... Class... Class... SHUT UP. Thank you.

    -PatP

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The guy's got 60+ posts. I don't think this is a homework problem.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Mar 2004
    Posts
    202
    may i know what do u mean by that?
    thanx

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    People on this forum are reluctant to answer what appear to be student's homework problems, and there was some speculation as to whether your issue is a legitimate business issue or just a class assignment.

    Since you have more than 60 posts on the forum, I didn't think you were just a student seeking assistance.

    If I'm right, post your table schema. If I'm wrong, then rephrase the assignment more generally and somebody here can at least point you in the right direction.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Mar 2004
    Posts
    202
    Hi there........

    I thinkn there are some misunderstanding here....................I'm now currently doing my practical with a company here based in malaysia which is part of my paper at university level.
    That's why i'm asking to many question as I'm not that familiar with the application.

Posting Permissions

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