In the FROM clause of the UPDATE statement you list the table 'Orders'.  My guess is you intend for this to be the CTE but if the schema is not...

I agree.  The answers are equivalent at best.

drop proc if exists dbo.test_case_cross;
go
create proc dbo.test_case_cross
  @node_order            int,
  @Record_Key_4    ...

Here's how I'm testing it.  I'm switching over to John and Jonathan's in the case where there are not nullable columns.  Still with the CROSS JOIN.  Wait a sec

• This reply was modified 5 years, 9 months ago by Steve Collins.

Yeah I'm getting counterexamples too including my own.  Which columns can be NULL?

...
from
  Popup_Switches ps
 cross join
  #temp_1 t
where
  ps.popup_gid in(2, 5)
  and t.node_order=1
  and (t.record_Key_4 = '1' or t.Record_Key_5 NOT IN ('I', 'X'));

It's an unusual query.  There's no join condition so it's really a CROSS JOIN.  I would guess the temp table always returns 1 row.  No matter what this query will...

Ha it's the exact same query.

with grupo_cte(idTipoGrupoCons, intIdEntidad, intIdEjercicio) as (
    select 16, 50, 7
    union all
    select 16, 45, 4
  ...

• This reply was modified 5 years, 9 months ago by Steve Collins. Reason: type

It's the size of the Excel file with the pivot table?

I think the trick is that we're all in the same boat, so stating why you oppose something but knowing that the final decision might be somewhere else is...

Now I work in marketing... the only thing...

In the FROM clause of the "main query" the table dbo.ShtStock had been LEFT JOINED to based on the ShtStockId.  I changed that to be the dbo.NZ(...) function.  The "main...

I don't think it's as much an attitude issue as it is a domain knowledge issue.  I wouldn't try to tell .Net developers how to write C# code, but...

Maybe the obscured error message contains some clues