Results 1 to 3 of 3

Thread: [RESOLVED] SQL Need to some help with this challenge

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2018

    Resolved [RESOLVED] SQL Need to some help with this challenge

    I have a big problem which I spent two days on with no apparent result.
    I need to define two states for each cases. Here is the story; I have a table containing the phase tracks of some cases. All cases start with “New” phase. If the case has been in “Approval” and then back to “New” the case has not been RFT (right first time). Otherwise they are RFT. So somehow I need to check if cases have been in “Approval” and then back to “New”. I thought of looping through each phase for each case and then do something when I see that pattern (going back from Approval to New). But then I thought nothing more

    Here are the tables:

    Name:  2019-04-14_16-53-30.jpg
Views: 66
Size:  50.9 KB

    I need the RFT column in table 2 to reflect the result.

    Any help is appreciated.
    Thanks in advance.
    Last edited by Grand; Apr 14th, 2019 at 11:22 AM.

Posting Permissions

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


Click Here to Expand Forum to Full Width