RE: update record from another record in same table

SSCarpal Tunnel

Points: 4718

May 1, 2013 at 9:27 am

update dbo.testTable set
fname = (select fname from dbo.testTable where pkid = 2)
where
pkid = 1;

Thanks Lynne!

if there were multiple columns would I just do the same for each column, ie:

update dbo.testTable set

fname = (select fname from dbo.testTable where pkid = 2),

lname = (select fname from dbo.testTable where pkid = 2),

address = (select address from dbo.testTable where pkid = 2

where

pkid = 1;