13 Replies Latest reply: Mar 14, 2016 10:14 PM by Rick Arora RSS

    While loop for creating dates between 1985 and 2016 - performance issues

    Rick Arora


      load  link_Sup_ADCNOBeginningDateofSupervision + IterNo()-1 as Dup_analysis_date , S as Dup_S
      from resident Supervision      while IterNo() <= Supervision_End_Date - BeginningDateofSupervision +1 ;




      The statement above is running in the application for more than 2 hours.  I have posted this issue to others and received some good feedback to pull data from the resident table.


      But I am still having performance issues , any ideas on how to make this while statement run faster and more efficiently?