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
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