Use the Table to Be Modified As Temporary Storage For Itself

R. Barry Young is an active member and occasional presenter at the Philadelphia SQL Server Users Group, PSSUG.  His presentations are known for his touch of humor.  I still chuckle about the “Dude Where’s My Error” comment in his Object Broker presentation. 

Recently, SQL Server Central reposted an article of Barry’s that is worth a look.  He takes an old school approach to a common problem.  The technique demonstrates an “In-Place” storage of intermediary data for the modification of data in the same table.  That is he uses the existing table that is already populated with data to store a modified version of the data that is needed as a step in a data modification process.

The article is well thought out with very clear explanations and examples running from start to finish.  You may never need this technique but understanding it and having it tucked away in the tool box is a worthy investment of 15 minutes. – Good Job Barry

Just For Fun: An Impossible Delete
http://www.sqlservercentral.com/articles/T-SQL/63578/

SQLServerCentral.com does require an account to access content.  Accounts are free and can include a subscription to their daily news letter.

Comments

[RBarryYoung]

Hey, that's me! Thanks, Josh! :-)