by Pieter Brinkman
23. August 2009 03:04
With common table expressions you can save the results to a temporary result set and use this results set for other queries.
[code:tsql]
WITH temporaryNamedResultSet
AS
(
select UserName from aspnet_Users
)
select * from temporaryNamedResultSet
[/code]
Subscribe