Sorry to bump this thread, but I've run into a minor issue.
When I re-open the view that uses this code, this part...
WITH CTE AS
(
Is GONE, which causes an incorrect syntax error.
Any idea why MSSMS would truncate (delete) that part?
- This reply was modified 4 months, 3 weeks ago by tsobiech.