WITH y AS (
    WITH x AS (
        SELECT * FROM MyTable
    )
    SELECT * FROM x
)
SELECT * FROM y

Does something like this work? I tried it earlier but I couldn’t get it to work.

7 Answers
7

Leave a Reply

Your email address will not be published. Required fields are marked *