How to Update a Single Table with multiple join

Wednesday, July 28th, 2010

In one of my last assignment I had to do some enhancement to the existing stored procedure written in SQL Server 2008. I noticed bunch of lines of sql code written to update a single table inside and using while loop because of a check where key field should exist in other table. I was [...]