why can't I access my CTE after I used it once?

Viewed 16185

My stored procedure looks like:

WITH MYCTE(....)
AS 
(
...
)

UPDATE ... (using my CTE)



DELETE ( using my CTE)  <---  says the object, my CTE, doesn't exist

Can I only use it once?

4 Answers
Related