Insert Help  
Author Message
Johnnymag





PostPosted: Tue Jul 27 17:27:14 CDT 2004 Top

SQL Server Developer >> Insert Help

I have a table called Mixer and with (Mixno int, Mixname varchar(50), Mixop int)
I have a sp that updates this table daily. I would like to export the old values in Mixno, Mixname, and Mixop into a new table called Mixold. Before any updates are applied.

Is it something like this

Insert into Mixold (Mixno,Mixname,Mixop) values (OLDmixno, OLDMixname, OLDMixop)

SQL Server238  
 
 
Tom





PostPosted: Tue Jul 27 17:27:14 CDT 2004 Top

SQL Server Developer >> Insert Help Try:

Insert into Mixold (Mixno,Mixname,Mixop)
select
Mixno,Mixname,Mixop
from
Mixer


--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.


I have a table called Mixer and with (Mixno int, Mixname varchar(50), Mixop
int)
I have a sp that updates this table daily. I would like to export the old
values in Mixno, Mixname, and Mixop into a new table called Mixold. Before
any updates are applied.

Is it something like this

Insert into Mixold (Mixno,Mixname,Mixop) values (OLDmixno, OLDMixname,
OLDMixop)