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

       

      tyvm

       

      Simone