SQL Server CTE with multiple delete statements

Question

I have a CTE:

;WITH DeleteTarget AS
(
    ....
)

How do I use this CTE for two delete statements - maybe like:

DELETE FROM [TableA]
WHERE ColumnA IN (SELECT Id FROM DeleteTarget)

DELETE FROM [TableB]
WHERE ColumnB IN (SELECT Name FROM DeleteTarget)

marc_s · Accepted Answer · 2017-11-10 09:54:52Z

5

You cannot - a CTE only exists for the one, next statement.

If you need this information that the CTE provides more than once, you need to:

answered Nov 10, 2017 at 9:54

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1