InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 14:24:25 GMT20http://www.sqlservercentral.com/Forums/Topic426283-338-1.aspxHTHWed, 28 Nov 2007 08:01:05 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic426283-338-1.aspxHi ALZDBA, Thanks a lot. Its working fine.:)Wed, 28 Nov 2007 06:10:08 GMTSqlUser-529296http://www.sqlservercentral.com/Forums/Topic426283-338-1.aspxif you can join the objects it may be pritty easy[code]begin transaction update T1set col1=T2.colxfrom mytable T1inner join myothertable T2on T1.mycol = T2.mycoltoowhere [/code]is it ok ?[code]-- rollback tran -- commit tran[/code]Tue, 27 Nov 2007 05:14:17 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic426283-338-1.aspxNeeded more clarity for the postTue, 27 Nov 2007 04:56:13 GMTvyashttp://www.sqlservercentral.com/Forums/Topic426283-338-1.aspxHi,I just want to update a column in a table,values from another table.Values should return more than 1, say 15(according to condition in the select statement).Without using of temp tables. Thanks in Advance.Tue, 27 Nov 2007 04:48:07 GMTSqlUser-529296