Thanks for your reply. Sorry, I didn't clarify in my example that I don't want the literal text "exec sp_DisplayTree(C.CatID)" to be displayed in the column. I need the sp to run for every column to return a dynamic result for every row.
My sp_DisplayTree(C.CatID) returns the following single column:
Home : Music : Artists
I want the following output:
CatID | CatTitle | CatTree
009 | Artists | Home : Music : Artists