I need to update another table 'table3' also ( same structure as 'table1')

i need to update another table 'table3' also .(same structure as table1)

?

here is the sample query

DECLARE @Addr1 bigint;

DECLARE @Addr2 bigint;

DECALRE@Timedatetime;

declare GET_Details cursor

for

select COl_Addr1,COl_Addr2 ,COl_Time from TABLE2

open GET_Details;

FETCH NEXT FROM GET_Details INTO @Addr1,@Addr2 @Time;

WHILE @@FETCH_STATUS = 0

BEGIN

BEGIN TRANSACTION

UPDATE TABLE1 SET =COl_Addr2

where...

My concern is the table 'Table1' is filled with large amount of data in minutes. and i need to update that table after the comparion with the 'table2'.

Insertion and updation...

is it possible to fetch multiple columns (using cursor)

thanx

database will flooded with GBs of data in each day .i used to archive data in day wise.

The actual problem is when querying some thing from huge data ,...

thanks