Thanks for the reply.  No, I don't need DST.  Dates in databases are always in CST, so I need to make sure to convert the computer time to CST and...

VS 2015.  But I tried on VS 2017 and still didn't work.

That was too obvious and too easy.  Of course...

This is a great article and I have always struggled with temporal data, every time needing a special case.  Unfortunately for me, I am not yet using SQL 2016 and...

I can always change a select-insert into a merge. There's never going to be a "WHEN MATCHED". Must try to see if it solves the problem.

Again on data compression - eventually the data will have to be archived in a database on a different server.  If both the operational and archived tables are compressed, how...

Thanks for the response.  Good point about data compression, I didn't think about that. Compression will slow down data inserts, but it will speed up data retrieval as it will reduce...

SQL Server, in particular SQL Server 2014, has performance issues with left join, especially when compared to inner joins. I do not know how merge was implemented by Microsoft, but...

Thanks.  I had forgotten about the connection timeout.

I give credit, where credit is due 🙂

Yes, but the most I've seen in my scenarios is about...

CREATE FUNCTION [dbo].[FN_ListToTable_8K]

(

@listVARCHAR(8000),

@delimiterCHAR(1)

)

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

--

-- Thist function has had...

N_Muller (11/30/2016)

---

Alan.B (11/29/2016)

---

My solution can be totally optimized and simplified but here's a solution that uses DelimitedSplit8K (see the link in my signature):

You'll notice three UNION ALL's. The first query...