Extracting All The Words From a String

Hi all,
I have written this BAQ for creating a list of extracted words from a string,
based on a solution I found here: reference

I get the results but with errors:

The maximum recursion 100 has been exhausted before statement completion.

Please help me sort this out.
Thanks
Himal

Here is my Query Phrase:

with [SubQuery1] as 
(select 
	[JobAsmbl].[JobNum] as [JobAsmbl_JobNum],
	[JobAsmbl].[AssemblySeq] as [JobAsmbl_AssemblySeq],
	[JobAsmbl].[Description] as [JobAsmbl_Description],
	(case
   when charindex(' ',JobAsmbl.Description)=0 then JobAsmbl.Description
   else
   left(JobAsmbl.Description,charindex(' ',JobAsmbl.Description)-1)
     end) as [Calculated_result1],
	(1) as [Calculated_Position],
	(case
    when charindex(' ',JobAsmbl.Description)=0 then NULL
   else
   right(JobAsmbl.Description,len(JobAsmbl.Description) - charindex(' ',JobAsmbl.Description))
     end) as [Calculated_RestOfLine]
from Erp.JobAsmbl as JobAsmbl
where (JobAsmbl.JobNum = 'HGTestingJob2'  and not JobAsmbl.AssemblySeq = 0)
union all
select 
	[JobAsmbl2].[JobNum] as [JobAsmbl2_JobNum],
	[JobAsmbl2].[AssemblySeq] as [JobAsmbl2_AssemblySeq],
	[JobAsmbl2].[Description] as [JobAsmbl2_Description],
	(case
    when charindex(' ',SubQuery1.Calculated_RestOfLine)=0 then SubQuery1.Calculated_RestOfLine
    else
    left(SubQuery1.Calculated_RestOfLine,charindex(' ',SubQuery1.Calculated_RestOfLine)-1)
      end) as [Calculated_result2],
	(SubQuery1.Calculated_Position + 1) as [Calculated_PositionB],
	(case
    when charindex(' ',SubQuery1.Calculated_RestOfLine)=0 then NULL
    else
    right(SubQuery1.Calculated_RestOfLine,len(SubQuery1.Calculated_RestOfLine) - charindex(' ',SubQuery1.Calculated_RestOfLine))
      end) as [Calculated_RestOfLineB]
from Erp.JobAsmbl as JobAsmbl2
inner join  SubQuery1  as SubQuery1 on 
	SubQuery1.JobAsmbl_JobNum = JobAsmbl2.JobNum
	and SubQuery1.JobAsmbl_AssemblySeq = JobAsmbl2.AssemblySeq)

select 
	[SubQuery11].[JobAsmbl_JobNum] as [JobAsmbl_JobNum],
	[SubQuery11].[JobAsmbl_AssemblySeq] as [JobAsmbl_AssemblySeq],
	[SubQuery11].[JobAsmbl_Description] as [JobAsmbl_Description],
	[SubQuery11].[Calculated_result1] as [Calculated_result1],
	[SubQuery11].[Calculated_Position] as [Calculated_Position],
	[SubQuery11].[Calculated_RestOfLine] as [Calculated_RestOfLine]
from  SubQuery1  as SubQuery11

There’s no “way to sort it out” you are hitting a limit in SQL, which you can override but only to a point… May I ask what your end goal is? Perhaps there’s a better way

nevermind,
added a subquery criteria to hide blank results.