According to the timestamps you answered your own question half a day before it was even asked!

You could create a table (b_tree) to store your numeric data in a single column.  Then assign additional columns based on common attributes of the numbers.

column1: your numbers

column2: applies to...

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 6 years, 4 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 6 years, 4 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...