2 Replies Latest reply: Nov 1, 2018 2:30 PM by Justin Dallas RSS

    RecNo or RowNo to show duplicates ?

    Claudia Lettten

      Hi here is my script . This load contains duplicate rows and I need to display the duplicates in a table.

      Where do I place the RecNo ()   or RowNo ()  to do this ?




      [Sales] ,

      [Order] ,


      [SortOrder] ,


      RESIDENT [Table];

      DROP TABLE [Table];

      RENAME TABLE  [Table] to [List];