ChrisM@Work (1/5/2016)

---

Hi Alan, nice job 🙂

Here's a completely different take on the problem, loosely based on some fuzzy matching stuff I've worked on over the years. It looks promising and...

Hi Alan and thank you for sharing this problem and this very fine post, good job indeed. I've been swamped with work but will have a go at it as...

Piling on, here is the short disco version

😎

SELECT OBJECT_DEFINITION(OBJECT_ID(N'[schema_name].[object_name]'));

Thank you Robert for this excellent piece, good job and a very good reference indeed.

😎

The greatest disadvantages I find with the DATETIME2 data type are firstly the default precicion of...

Jeff Moden (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Jeff Moden (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Further on Jeff's correction, the ClientID in the sample data is different from the one hard coded in the procedure, change these...

Jeff Moden (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Further on Jeff's correction, the ClientID in the sample data is different from the one hard coded in the procedure, change these two things and you...

Further on Jeff's correction, the ClientID in the sample data is different from the one hard coded in the procedure, change these two things and you will get back two...

Are you using MySQL/MariaDB? This is an enumeration/identity column on those rdbms

😎

For fun and completion, comparison of the previously posted "short" methods

😎

Test harness

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 2000000;

--/*

IF OBJECT_ID(N'dbo.TBL_METHOD_TEST' ) IS NOT...

Alvin Ramard (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Alvin Ramard (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Jeff Moden (1/4/2016)

---

Lynn Pettis (1/4/2016)

---

Good question. Just one minor thing, I'd use the following the end of the calendar year:

SELECT DATEADD(DAY,...

That makes things somewhat easier, how complex are the schemas and what is the cardinality?

😎

Alvin Ramard (1/4/2016)

---

Eirikur Eiriksson (1/4/2016)

---

Jeff Moden (1/4/2016)

---

Lynn Pettis (1/4/2016)

---

Good question. Just one minor thing, I'd use the following the end of the calendar year:

SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0,...

Jeff Moden (1/4/2016)

---

With...

Slow / lazy...

Quick question, what is the recovery window's size, that is how much time can you spend on reverting?

😎