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, 7 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

So "TimeDayId" is not a particularly accurate name for a DATE type column imo.  My suggestion would be to rename the column to "DayDate" or something similar

Not tested on Sql 2008 but it should work afaik.

--drop table if exists dbo.test_process_statuses;
--go
create table dbo.test_process_statuses(
  ProcessKeyId         ...

Is this really sql 2008?

Nevermind

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

Thanks Phil I'm a big fan of your articles.  I completely agree JSON can be a key element of efficient application data access.  As far as data validation goes tho... ...

with
other_parts_cte as (
    select
      p.PartId, t.maskId, t.chemicalid
    from
      #temp t
 ...