Who cares what language the columns names are in? We can't offer much help because we can't see your screen, have no idea what your data structures are like, no...

cte1

as

select table2.field1, table2.field2

from table2

where...

--table3.field1 not the same value than table2.field1

cte2

as

select table3.field1, table3.field2

from table3

inner join CTE1

union table3.field2 on CTE1.FIELD2

where ...

select cte1.field1,cte1.field2

from cte1

union all

select cte2.field1,cte2.field2

from cte2

It...

I'm not showing my code is because it's so much long and Field are in french.

Basically

I want to select cte1 union all cte2 but cte2 uses cte1 and cte1...

Really

So I probably need a new stored procedure !

-- impossible to do any select on cte except on real table or table variable after I did a insert into because I got (Invalid object name ) when ...

I know about he "*" it's just a example.

I don't use Cte2 anywhere except to insert into the table variable. Just easier to read and understand to put the long...

With an alias on table variable I'm able to use it. I just don't know why sql server need an alias to work.

Sorry it's in a query in french but you got the idea.

here an inline table value function.

basically I check purcharse order, after I check product finish, after product half...

Hi

I've conditional expression with IIF function and "=" in and view show me error in sql pane.

CTE is fine but I want able to use the query with...

while copying my code I see a typo in declaring #table1 into procb. So it's all fine now

thanks

thanks man !

how is working the parameter (N)

mainly this part : ROW_NUMBER() OVER(ORDER BY (SELECT NULL)

row_number is from top ?

over ? never see this

select null ? why null ?

thanks for second solution but for the moment I don't understand completely the function

Anyway I can't use the recursive function for over 100...

The maximum recursion 100 has been exhausted before statement completion.

wow just great

thanks !

I didn't know that you can use recursive cte !