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..
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madhu sudhan g
Hiii
DELETE T1
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T2
DELETE T2
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T3
DELETE T3
OUTPUT DELETED.COLUMN1,DELETED.COLUMN2...
INTO T4
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siva
insert into T1
select *from t2
union/union all (without duplicates/with duplicates )
select *from t3
union/union all
select *from t4
.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gaurav
dear u can do like
insert into t2 select * from t1
insert into t3 select * from t2
.
.
.
.
so on
Is This Answer Correct ? | 1 Yes | 4 No |
How does a profiler work?
What are alternate keys?
Can two tables have the same primary key?
What do you mean by SQL injection attack?
what is a stored procedure and trigger?
What are the differences between ms sql server & oracle?
Using the customer, and order table in northwind database, please write a query to produce xml?
what is maximum size of temp db?
What function does a database engine serve in the sql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is a view and what are its advantages?
Explain full-text indexing?