tags:

views:

98

answers:

1

How to add new data(multiple rows) in sql table without deleteing existing data. My table is

id Location Name User ID LogDate LogTime

1 Mumbai Shanks 0001 11-Aug-09 15:15:20

1 Mumbai Shanks 0001 11-Aug-09 15:25:28

1 Mumbai Shanks 0001 11-Aug-09 16:35:56

2 Delhi Mahen 0002 11-Aug-09 02:25:50

This table is used for Time attendance for employee

A: 

I'm unclear on what you want to do. Would you like to use existing values in the table to compute new values and then add that to the table? You might want to tag this with sql as well (I can't yet due to my rep).

Oren