рекурсивный запрос в T-SQL

gistfile1.sql

WITH PCommentList ([ProductId]
      ,[ProductCommentId]
      ,[ProductCommentPId]
      ,[ProductCommentText]
      ,[ProductCommentAddDate]
      ,[ProductCommentAddUserId]
      ,[ProductCommentAddUserName]
      ,[IsApproved]
      ,[IsLocked])
      AS(
	
  SELECT *
	  FROM [basename].[dbo].[ProductComments]
	  WHERE [ProductCommentId] = 113 --- id того сообщения которого возвращаем ветку
  UNION ALL
  
  SELECT comm.*
	  FROM [basename].[dbo].[ProductComments] as comm
	  Inner JOIN PCommentList as pl
  ON comm.ProductCommentPId = pl.ProductCommentId
  
  )
  
  
  SELECT * FROM PCommentList;