Rescue

neomerdien (1/7/2016)

---

Hi,

looks really good, thanks!

so just to make sure, i need to replace TBL_TEST_AUDIT with my table and my columns and i cant audit the deletes in question, correct?

also, im...

Quick suggestion, just make certain that the right indices are in place.

😎

/* SELECT GIVING THE DESIRED OUTPUT */

SELECT

AC.ID

,AC.AcctID

,MAX(TT.tpyModifiedDate) AS tpyModifiedDate

FROM...

lsalih (1/6/2016)

---

Perfect, it worked like a charm! Now I have one last question to ask: The ultimate goal is after we group the data is to extract each subset of...

Quick solution in line with Jason's suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(SD_ID,SD_DATE) AS

( SELECT SD_ID,CONVERT(DATE,SD_DATE,120) FROM

( VALUES

...

Jeff Moden (1/5/2016)

---

Careful now... Does it? With...

neomerdien (1/6/2016)

---

i understand.

lets say this is my table, so you can use that as a reference:

TABLE [test1]

ID [int] NOT NULL,

ExpDate [datetime] NOT NULL

i want to log all the deletes from...

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