InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 07:02:41 GMT20http://www.sqlservercentral.com/Forums/Topic1428500-1292-1.aspxDavid,Thanks very much.[code]DECLARE @Col2 decimal,@Col3 int,@Col4 intSELECT @Col2 = [Col 2],@Col3 = [Col 3],@Col4 = [Col 4]FROM [table]WHERE [Col 1] = 10000 UPDATE [table] SET [Col 2] = @Col2, [Col 3] = @Col3, [Col 4] = @Col4 WHERE [Col 1] > 10000 [/code]Did exactly what was required.Fri, 08 Mar 2013 07:53:47 GMTgj.thorpehttp://www.sqlservercentral.com/Forums/Topic1428500-1292-1.aspx[quote][b]ryan.mcatee (3/8/2013)[/b][hr]I think you want something like this?[/quote]or[code="sql"]UPDATE a SET a.[Col 2] = b.[Col 2], a.[Col 3] = b.[Col 3], a.[Col 4] = b.[Col 4] JOIN [table] b ON b.[Col 1] = 10000 WHERE a.[Col 1] > 10000 [/code]or [code="sql"]DECLARE @Col2 decimal,@Col3 int,@Col4 intSELECT @Col2 = [Col 2],@Col3 = [Col 3],@Col4 = [Col 4]FROM [table]WHERE [Col 1] = 10000 UPDATE [table] SET [Col 2] = @Col2, [Col 3] = @Col3, [Col 4] = @Col4 WHERE [Col 1] > 10000 [/code]Fri, 08 Mar 2013 06:51:23 GMTDavid Burrowshttp://www.sqlservercentral.com/Forums/Topic1428500-1292-1.aspxI think you want something like this?[code="sql"]UPDATE {table}SET [Col 2]=(SELECT [Col 2] FROM {table} WHERE [Col 1]=10000) , [Col 3]=(SELECT [Col 3] FROM {table} WHERE [Col 1]=10000) , [Col 4]=(SELECT [Col 4] FROM {table} WHERE [Col 1]=10000)[/code]Edit: Misread this. And I am assuming [Col 1] is unique.Fri, 08 Mar 2013 06:03:32 GMTryan.mcateehttp://www.sqlservercentral.com/Forums/Topic1428500-1292-1.aspxI have a table where I need to update multiple columns in each record (multiple rows) to match a single record already in the table.For example:[code]Col 1 Col 2 Col 3 Col 410000 20.00 1 010001 0 0 110002 15.00 1 010003 0 0 0[/code]So, for the above I would like to update values in Col 2, Col 3, Col 4 for records in (10001, 10002, 10003) to match values in Col 2, Col 3, Col 4 where Col 1 = 10000I would like the data to end up like:[code]Col 1 Col 2 Col 3 Col 410000 20.00 1 010001 20.00 1 010002 20.00 1 010003 20.00 1 0[/code]Is it possible to do this in a single statement?Fri, 08 Mar 2013 03:54:52 GMTgj.thorpe