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

To insert into a column of type DATE in SQL...

The 2nd item in the select list is not included in the GROUP BY clause.  Shouldn't it be?  The tables which are nested inside the STUFF function join to the...

• This reply was modified 4 years, 10 months ago by  Steve Collins.

select substring(@text, len(@text)-11, 8);

You marked your own answer as the answer?  Nicely done!

declare
  @text               ...

• This reply was modified 4 years, 10 months ago by  Steve Collins. Reason: now looks for reverse('_files')