copy rows within a table

• Tim Chapman-309587

  SSC Rookie

  Points: 28

  More actions

  March 12, 2006 at 2:41 pm

  #111440

  I would like to take row in a table and update other existing rows so they copy all columns of this row exactly, (except the PK of course).

  Is there a short way of doing this without lots of variables and update, (SET x = @x) statements?

   

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  March 12, 2006 at 3:03 pm

  #626151

  UPDATE MyTable

  SET ColA = A.ColA,

  ColB = A.ColB,

  ....

  FROM MyTable A

  WHERE A.ColX = @Value

  _____________
  Code for TallyGenerator

• alexia-294642

  SSChasing Mays

  Points: 600

  More actions

  March 16, 2006 at 2:59 am

  #626964

  try this one :

  declare @colA varchar(50),@colB varchar(50),@colC varchar(50)

    select @colA=colA,@colB=colB,@colC=colC from tblX

     where id = '1' -- this is the one that you want to get the data from

  update tblX

  set colA=@colA,colB=@colB,colC=@colC

  where id <> '1'