copy row in same table
747821Jun 30 2010 — edited Jun 30 2010i have a table is has around 40 rows
i have many roecords of it
i want just copy one whole row and insert in another lot_number name which is primary key
how i insert same row with different lot_number?
is there any technique?