The error was on a line about 50 lines before the one it was reporting, I'd forgotten to add an @ to the beginning of one of my variables when...

A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Tres bizarre.

Use an instead of delete trigger.