SQL Update Multiple Fields FROM via a SELECT Statement

Question

This works, but i would like to remove the redundancy. Is there a way to merge the update with a single select statement so i don't have to use vars?

    DECLARE         @OrgAddress1 varchar,         @OrgAddress2 varchar,         @OrgCity varchar,         @OrgState varchar,         @OrgZip varchar,         @DestAddress1 varchar,         @DestAddress2 varchar,         @DestCity varchar,         @DestState varchar,         @DestZip varchar      SELECT          @OrgAddress1    =   OrgAddress,         @OrgAddress2    =   OrgAddress2,         @OrgCity        =   OrgCity,         @OrgState       =   OrgState,         @OrgZip         =   OrgZip,         @DestAddress1   =   DestAddress,         @DestAddress2   =   DestAddress2,         @DestCity       =   DestCity,         @DestState      =   DestState,         @DestZip        =   DestZip     FROM          ProfilerTest.dbo.BookingDetails      WHERE          MyID=@MyID      UPDATE SHIPMENT     SET         OrgAddress1     =   @OrgAddress1,         OrgAddress2     =   @OrgAddress2,         OrgCity         =   @OrgCity,         OrgState        =   @OrgState,         OrgZip          =   @OrgZip,         DestAddress1    =   @DestAddress1,         DestAddress2    =   @DestAddress2,         DestCity        =   @DestCity,         DestState       =   @DestState,         DestZip         =   @DestZip     WHERE          MyID2=@ MyID2 

Answer 1

Something like this should work (can't test it right now - from memory):

UPDATE SHIPMENT SET   OrgAddress1     = BD.OrgAddress1,   OrgAddress2     = BD.OrgAddress2,   OrgCity         = BD.OrgCity,   OrgState        = BD.OrgState,   OrgZip          = BD.OrgZip,   DestAddress1    = BD.DestAddress1,   DestAddress2    = BD.DestAddress2,   DestCity        = BD.DestCity,   DestState       = BD.DestState,   DestZip         = BD.DestZip FROM    BookingDetails BD WHERE     SHIPMENT.MyID2 = @MyID2    AND    BD.MyID = @MyID 

Does that help?