Where are you trying to run it from? Wherever it is, it is trying to run it as an “update”, when you really want it to run like a select. You’ll likely need to use the system.db.runQuery scripting function or something similar. And in that case, it’ll probably be easier to wrap it up in a stored procedure and just call that.
Regards,