0 - 3 of 3 tags for error 6926

I've been struggling to get the following piece of code to work - is there no way to get the working select statement below (See comment ** Working **) to work within a view?

First of all, thanks for this amazing forum and for all the help provided!

I found 3 previous posts on this topic, but I don't think the answers were suffucuent for my case. I am trying to create this view:



Hi everyone,

I am trying to create a recursive view and get the ERROR

REPLACE VIEW Failed. 6926:  definitions, views, triggers or stored procedures. 

Added the code, has anybody any suggestions?

Thank you in advance.