19 Replies Latest reply: Feb 26, 2014 5:32 AM by Massimo Grossi RSS

    sql select for each day

      Hi all,


      i have a select like this :


      sql select table.name, table.surname, table.age

      from table

      where table.borndate = vDday


      I need vDay loops between 2 values(i.e. 20120101 and sysdate)


      Result set will be a list of record for each day