Skip to content
Advertisement

SQL server error in regards to common table expression [closed]

I have this query:

I am getting this error:

I have no idea how to fix this or why I am getting this error, please let me know what I can do to fix this. It seems I need a semicolon somewhere but for the life of me I cant figure out where or why. Any suggestions would be really appreciated. The error message does not really give clear indication as to where I need to fix the problem.

Advertisement

Answer

your code need like below, so you have to remove 2nd with

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement