How to work with CTE. There is some error related to anchor.
- by Shantanu Gupta
I am creating a hierarchy representaion of a column. But an error occurs
Details are
Msg 240, Level 16, State 1, Line 1
Types don't match between the anchor
and the recursive part in column
"DISPLAY" of recursive query "CTE".
I know there is some typecasting error. But I dont know how to remove error. Please just dont only sort out my…