Selecting MAX value in 1 column based on code in another column?

  • 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 1 year, 1 month ago by tsobiech.

Viewing post 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply