updating data from one table to another 1

[angela4eva]

hello,
I am trying to update update a crunk of data from one table to another.The table have same fields(names and types).I want to update the data in newtable with the data in old table for classid=24.how can i do this.please help

 

[AlexCuse]

insert into NEWTABLE
select * from OLDTABLE where classid = 24

YOu'll want to replace * with your field names if possible...

A wise man once said
"The only thing normal about database guys is their tables".

 

[SQLDenis]

something like this

update t1
set t1.col1 =t2.col1,
t1.col2 =t2.col2,
....
...
..
from table1 t1 
join table2 t2 on t1.classid = t2.classid
and <all the other columns here>
where t2.classid = 24

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[angela4eva]

thanks guys but is there no other way of doing it..i mean more easier

 

[AlexCuse]

I misread your post, Denis is right.

And no there is no way that is easier.

A wise man once said
"The only thing normal about database guys is their tables".

 

[SQLDenis]

>>i mean more easier

sure

delete newtable where classid = 24


insert into NEWTABLE
select * from OLDTABLE where classid = 24

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/