I'm using the WITH statement on a view, and it doesn't work. However, when I create a subquery instead, it works. I was wondering why that is.
Error:
Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.