The maximum recursion 100 has been exhausted before statement completion.

USE [Db_GoldenCoin]
GO
/****** Object:  StoredProcedure [dbo].[getDownLineWithPaging]    Script Date: 04/06/2016 23:28:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[getDownLineWithPaging]
@SearchTerm varchar(100)='',
@PageIndex int=1,
@PageSize int=10,
@mid varchar(20),
@RecordCount int Output
AS
Begin
set NOCOUNT ON;
with DownLineCTE as
(
SELECT tbl_MemberTransaction.MemberId, tbl_MemberTransaction.PlacemMentID
from tbl_MemberTransaction
where tbl_MemberTransaction.PlacemMentID=@mid

UNION ALL

SELECT tbl_MemberTransaction.MemberId, tbl_MemberTransaction.PlacemMentID
FROM tbl_MemberTransaction
JOIN DownLineCTE
ON tbl_MemberTransaction.PlacemMentID=DownLineCTE.MemberId
)

SELECT ROW_NUMBER() OVER
(
ORDER BY m.MemberId ASC
)AS RowNumber,
m.MemberId, MemberName=m.MemberFirstName+' '+ m.MemberLastName,t.SponceID,t.PlacemMentID, m.MobileNumber,pc.PkgName,JoiningDate=CONVERT(VARCHAR(10), m.JoiningDate, 103) 
INTO #Results 
FROM DownLineCTE as ct
LEFT join tbl_MemberMaster as m
ON m.MemberId=ct.MemberId
LEFT JOIN tbl_MemberTransaction as t
ON m.MemberId= t.MemberId
LEFT JOIN tbl_PINDetails as pd
ON m.SecurityPIN = pd.PIN
LEFT JOIN tbl_PinTransferTbl as pt
ON pd.TransferId= pt.PinTransferId
LEFT JOIN tbl_PackageMaster pc
ON pt.PackageId= pc.PkgId
WHERE m.MemberId LIKE @SearchTerm +'%' OR m.MemberFirstName LIKE @SearchTerm +'%'
OR m.MemberLastName LIKE @SearchTerm + '%' OR m.MobileNumber LIKE @SearchTerm +'%'
OR t.SponceID LIKE @SearchTerm + '%' OR t.PlacemMentID LIKE @SearchTerm + '%'

SELECT @RecordCount=COUNT(*)
  FROM #Results
          
      SELECT * FROM #Results 
      WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1
    
      DROP TABLE #Results

      
END