I have created this table and is accessing it via an aspx web form. I would like to know if it possible to update the table sending the update data to a different table in the database. If Yes how do I accomplish that?
Trafmore



CREATE TABLE dbo.TimeSheet(
dt SMALLDATETIME PRIMARY KEY CLUSTERED,
isWeekDay AS CONVERT(BIT, CASE
WHEN DATEPART(dw, dt) IN (1,7) THEN 0
ELSE 1 END),
Hours_On_Duty VarChar DEFAULT 10.0,
UnpaidOT VarChar,
PaidOT VarChar,
Admin VarChar DEFAULT 10.0,
Court VarChar,
INSTR VarChar,
STDNT varChar,
COMM_SERV VarChar,
VICT_SERV VarChar,
Remarks varChar
);
GO

DECLARE @dt SMALLDATETIME;
SET @dt = '20070101';
WHILE @dt<= '20071231'
BEGIN
INSERT dbo.TimeSheet(dt) SELECT @dt;
SET @dt = @dt + 1;
END