frederico_fonseca thank you!!

@EdB thank you. It works. I appreciate your help.

@Ed B  thank you. I am not a 100% sure I understand what I need to do.

I pasted my whole query:

Let me know if that is what I need to...

• This reply was modified 2 years ago by  JeremyU.

Kaj Thank you very much. It works. Thank you.

@Phil Parkin I cannot provide such information. I don't know how and I am not sure I am allowed.

I managed to do something similar to what I need but it...

Thank you.

I think it works. Thank you. One more issue though.

I am not sure why but this part doesn't work  WHEN S1UPSP LIKE 'RIOUS%' THEN '0'

Sometimes I have RIOUS932 or some...

@steve-2 Collins it didn't help. I don't think the issue is in the join...

@steve-2 Collins

I did it and receive the same error.

I have a different kind of issue now. I identified that the problem was in a join ar.AR_STORE=wf.DESTR.

I need to create a join on this field ar.AR_STORE=wf.DESTR

I don't know but...

• This reply was modified 2 years, 3 months ago by  JeremyU.

Jeff I used that as well. It doesn't work. Let me know if you have other ideas. Thank you though.

@jeff how can I then correct it?

I need to filter WHERE  SMP_FLAG  ='x'.

It is constant only for WF_SMP CTE. But later when I add other tables, I start...

It is varchar if I understand correctly

It keeps loading for a long time. I don't see any result coming up from this.

Wf is an alias to a CTE called WF_SMP

WF_SMP is defined:  'X' AS SMP_FLAG

I am basically trying to get all the rows from CTE called 'Wf'.

I am using SSMS. Wf is an alias to a CTE called WF_SMP