Persistent WITH statement in SQL Server 2008

Asked Aug 08 '14 at 16:37

Active Aug 08 '14 at 16:37

Viewed 26 times

How can i keep in memory a table created by WITH statement until the end of script?

Example:

;WITH Group AS
(
    SELECT Name, LastName, Age FROM dbo.persons WHERE Age BETWEEN 25 AND 30
)
--Group table stays in memory until the following query
SELECT * FROM Group

--Group does not exist here.
SELECT * FROM Group WHERE AGE = 27

Thanks in advance

asked Aug 08 '14 at 16:37

CodeArtist

5,534
8
40
65

i want to know if it's possible by using `WITH` statement. – CodeArtist Aug 08 '14 at 16:39
It is definitely not possible when using a common table expression (CTE). You should use a temp table or table variable depending on how many records will be in it. – Dave.Gugg Aug 08 '14 at 16:43
@Dave.Gugg, any specific reason you are not making that an answer? – Rahul Aug 08 '14 at 17:02
NO, it's not possible. – Rahul Aug 08 '14 at 17:03

Persistent WITH statement in SQL Server 2008

0 Answers0