Sorry forgot to post the query for the new view which calls the view1 and the TVF:

CREATE VIEW vewFullSearchCategory AS

SELECT SPD.*,PLC.*

FROM vewSearchCategory AS SPD

OUTER APPLY sfGetPathLevelfmCategoryID(SPD.CategoryGUID) AS...

i was trying to get the columns in the TVF :CMSID ,

CategoryPath,

CategoryLevel0 ,

CategoryLevel1 ,

CategoryLevel2 ,

CategoryLevel3 ,

CategoryLevel4 ,

CategoryLevel5 ,

CategoryLevel6 ,

CategoryLevel7 ,

CategoryLevel8 ,

CategoryLevel9 ,

CategoryLevel10

added to the view1...so finally i have...