SQL Code Piece : Update Temp Table with Self Referenced Values

---

UPDATE #TempSCR

SET ProgramName = P.Name

FROM #TempSCR t, TR_ProgramProfileHdr P

WHERE t.ProgramID = P.ProgramID

And P.ProjectID=4

Dragon Puzzle