TSQL: Use common table expression
With common table expressions you can save the results to a temporary result set and use this results set for other queries.
WITH temporaryNamedResultSet AS ( select UserName from aspnet_Users ) select * from temporaryNamedResultSet
Pieter is Technical Marketing Manager for Sitecore Netherlands and owner of Gaatverweg.nl. He has more than ten years experience with software developing in multiple programming languages and with different Content Management Systems. Before joining Sitecore Pieter was a lead developer for multiple Sitecore and .Net projects, he joined Sitecore in 2011 as an Solution Architect in The Netherlands, after two years as an Solution Architect he joined the Technical Marketing department. In the role as Techinical Marketing Manager he is responsible for the Global MVP program and the Sitecore technical branding strategy. You can follow Pieter on twitter: @pieterbrink123 or Google+
0 Responses to TSQL: Use common table expression