Home Forums SQL Server 2008 T-SQL (SS2K8) update record from another record in same table RE: update record from another record in same table

  • May 1, 2013 at 9:03 am

    #1611582

    Marcus Farrugia (5/1/2013)

    Hi, I'm looking for the best way to update pkid 1 = pkid 2

    update testTable

    set

    a.fname = b.fname

    from

    (select * from testTable where pkid = 1) as a

    join

    (select * from testTable where pkid = 2) as b

    This:

    update dbo.testTable set

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

    where

    pkid = 1;