Luis Cazares (1/8/2016)

---

Ed Wagner (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

rodjkidd (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

Here's a funny. The notification algorithm sent me an email from askssc.sqlservercentral.com telling me that I'd been mentioned in someone's query....

joe-584802 (1/6/2016)

---

Thanks Eirikur, that's awesome...!

Thank you for taking the trouble to give me such a comprehensive example, you've given me another road to go down which I'll pursue.

You are all...

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?