ChrisM@Work (1/6/2016)

---

Very fast code! It wouldn't take much...

Alan.B (1/6/2016)

---

Jeff Moden (1/6/2016)

---

Alan.B (1/5/2016)

---

SQLBill (1/5/2016)

---

Lynn Pettis (1/4/2016)

---

SQLBill (1/4/2016)

---

Lynn Pettis (1/4/2016)

---

SQLBill (1/4/2016)

---

I stayed up way longer than normal during the holiday break, but I forced myself to get in the...

Jeff Moden (1/6/2016)

---

SQLRNNR (1/6/2016)

---

Jeff Moden (12/29/2015)

---

That picture has always struck me... it's either a picture of Grant's back yard when he's BBQ'ing or a picture of Detroit on...

SQLRNNR (1/6/2016)

---

Eirikur Eiriksson (12/22/2015)

---

Michael L John (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

GilaMonster (12/22/2015)

---

Eirikur Eiriksson (12/22/2015)

---

One recent poster kept asking over and over again why he was getting an error whilst trying to do...

Jeff Moden (1/6/2016)

---

Alan.B (1/5/2016)

---

SQLBill (1/5/2016)

---

Lynn Pettis (1/4/2016)

---

SQLBill (1/4/2016)

---

Lynn Pettis (1/4/2016)

---

SQLBill (1/4/2016)

---

I stayed up way longer than normal during the holiday break, but I forced myself to get in the bed...

Just makes answering easier, otherwise one has to make it up.

😎

There are few patterns for doing this, what information do you need to capture in the audit?

Can you post the DDL for the table?

😎

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.testRN') IS NOT NULL DROP TABLE dbo.testRN

CREATE TABLE dbo.testRN

(

[id] [int] NOT NULL identity,

[rowdata] [nvarchar](10) NULL

)

INSERT INTO dbo.testRN...

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