[AccessD] Common Table Expressions - The solution to one of myproblems

I actually used this for the first time today and it worked just as advertised.  Way cool!

I have to do an update of a field in one of my tables based on a recordset where...  I defined the 
recordset where... and then performed the update on that, right in a single TSQL statement.

I used to create a view, store the view, then update the view.  Granted I am not very TSQL literate, 
but this method is just extremely easy / readable.  if I can do it anyone can.

John W. Colby
www.ColbyConsulting.com


Bill Patten wrote:
> Hey John,
> 
> Thanks, just what I needed for a project I'm working on.
> I have to start reading more than the editorials in the news letter.
> 
> 
> Bill
> 
> --------------------------------------------------
> From: "jwcolby" <jwcolby at colbyconsulting.com>
> Sent: Tuesday, December 08, 2009 5:09 AM
> To: "Dba-Sqlserver" <dba-sqlserver at databaseadvisors.com>; "Access Developers 
> discussion and problem solving" <accessd at databaseadvisors.com>
> Subject: [AccessD] Common Table Expressions - The solution to one of 
> myproblems
> 
> 
> http://www.sqlservercentral.com/articles/T-SQL/68651/
> 
> It looks way easy!
>