Yes yes.  Even if checks are performed in advance it's no guarantee the...

Then set the recovery model to "Trust Me We'll Be OK"

What happens if you restart the service?  According to the docs the service needs to be restarted after 'set sqlagent.enabled true'.  If that doesn't work I'd make a support call.

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 4 years, 10 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 4 years, 10 months ago by  Steve Collins. Reason: type

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