Just copy all data in T1 from T4. insert into T1 (select * from T4) N

i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..

i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used..

Question Posted / deepak

4 Answers
7756 Views
I also Faced
E-Mail Answers

Answer Posted / deepak

Just copy all data in T1 from T4.

insert into T1 (select * from T4)

Now do this assuming 'dateCol' contains the date:

delete from T4
insert into T4 (select * from T3)
delete from T3
insert into T3 (select * from T2)
delete from T2
insert into T2 (select * from T1 where year(dateCol) = 2002)
delete from T1 where year(dateCol) = 2002

This should move the data around without using temp table.

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is use of dbcc commands?

1074

What is entity data services?

1071

What are the differences between ms sql server & oracle?

1066

What are the characteristics of modern DBMS?

1092

How real and float literal values are rounded?

1159

What is inner join in sql server joins?

1041

Tell me about builtinadministrator?

1001

Why we use the openxml clause?

1016

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1166

What are the built in functions in sql server?

987

How to list all schemas in a database?

1064

Explain comment on transactions?

1005

What is linked report?

132

Explain an incremental backup?

1007

What is the recovery model?

993