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.
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.
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.