Thread: Update statement get executed but table remains the same

Dportas is right, MERGE would be preferable if it works in asyed01's environment. I was just lazy and provided the piece needed to get the posted statement to work instead of explaining why it was dangerous and better options for accomplishing the same purpose. In this case I should have done more than just get the code working. -PatP

Thank you so much guy for your replies to solve my problem and I learned from my mistake. Many Thanks again for showing me correct way. YOU ALL ARE BEST.

thank you remember we are equal some just more so

Code: UPDATE #TempTotalTable SET NoOfCol = #ColumnPerTable.NoOfCol FROM #TempTotalTable t1 INNER JOIN #ColumnPerTable t2 ON t1.TBName = t2.TBName

Your tables don't have any keys! That's your first problem. You are using Microsoft's version of the UPDATE statement with its FROM and JOIN clauses. That syntax suffers a pretty nasty design flaw that can cause unpredictable results when the joining criteria is not unique. If you are using SQL Server 2008 then I suggest you replace the UPDATE with MERGE, which is standard SQL, doesn't suffer the same problems as UPDATE and...