ALTER FUNCTION [dbo].[UsF_FetchChildsByGroupID]
(	
	@GroupId int
)
RETURNS TABLE 
AS
RETURN 
SELECT A.*, COUNT (T.TA_ID) AS Childs FROM
(SELECT TA_ID, TA_PID, TA_Name, TA_HomeFlag FROM TREEANIMALS
  WHERE TA_PID = @GroupId) A
 LEFT JOIN TREEANIMALS T ON (A.TA_ID = T.TA_PID)
 GROUP BY A.TA_ID, A.TA_PID, A.TA_Name, A.TA_HomeFlag