Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 7696 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
Can you move the resources after pausing the node? : sql server database administration
Tell about MOM Tool(Microsoft Operator Manager)?
How many partitions a clustered index has by default in sql server 2012?
How to add more data to the testing table in ms sql server?
How would we use distinct statement? What is its use?
What is federation member?
What are the different types of join?
What are the types of joins in sql?
Does hive support indexing?
How to list all dsn entries on your local machine using odbc_data_source()?
Why is the need for data conversion transformations?
last function used in MS Access to convert sql what function will use in sql
What are the new features of sql server 2012 reporting service?
Difference between uniqe index and uniqe constraint?
What are drilldown reports?
