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 6 years, 4 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 6 years, 4 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 6 years, 4 months ago by Steve Collins. Reason: now looks for reverse('_files')

Nicely done Mark Cowne.  My attempt avoids the inequality on date (which makes me nervous) but is otherwise the same.

with
t_rn_cte(person_from, person_to, kind, pctg_new, eff_date, row_num) as (
...

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

Here's an article from SSC:

https://www.sqlservercentral.com/articles/8-ways-to-export-sql-results-to-a-text-file

If it were me I'd use BCP, the Bulk Copy Program that comes with SQL Server.

What happens if you add TOP(1)?  Will any row convert or does every row fail?