The X isn't necessary. You asked about delete statements not working with aliases. That is merely a demo showing that aliases do in fact work with delete statements.
As for your query, attached as a download document I won't download it. Paste your query into a paste instead of as an attachment (that must be downloaded).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events