SQL server select and update

• David Sapp

  SSC Rookie

  Points: 30

  More actions

  June 6, 2006 at 6:20 am

  #171070

  Hi all,

  I need this quickly to give to my boss and wondering if anyone could help:

  I have three fields in table called "Abs", the fields are "Tpc", "Prp, "Frwk", "Fndgs", "Title" and "Mthds".  These fields are in the backup database and what I need to do is this:

  I need to do a select query to get these fields from the backup database, but then I need to do an update with the values returned from the select query and I would like to know how to do this.

  btw, its sql server 2000.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 6, 2006 at 8:04 am

  #642008

  David

  Not sure exactly what you're asking for, but here's a guess:

  insert into MyDB.dbo.Abs (Tpc, Prp, Frwk, Fndgs, Title, Mthds)

  select Tpc, Prp, Frwk, Fndgs, Title, Mthds from BackupDB.dbo.Abs

  John