RE: UPDATE from CTE – SQLServerCentral

SSC Guru

Points: 186127

January 5, 2009 at 3:08 pm

Philip Horan (1/5/2009)
Chris I was just playing with the CTE concept as I am quite new to TSQL.
Moving forward part of the learning process is to know when to employ the correct method as a solution for the problem.
Many thanks for your input.
Phil

Phil,

Best way to learn is to play. I'd never considered using a CTE in an UPDATE before, but right there's a new challenge - to find a scenario where a CTE is the right way to go. I reckon someone will post one within a day or so.

"part of the learning process is to know when to employ the correct method as a solution for the problem" - so you're an old git too, right? 🙂

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden