+1

😎

Didn't want to open that Pandora's box

Eric M Russell (1/20/2016)

---

Here you go. It's entirely possibly for multiple rows, or multiple columns within the same row, to tie for having highest date, so it will potentially return...

Sorry Gail, didn't see your post, makes mine look kind of daft:-P

😎

bebe022476 (1/20/2016)

---

How to optimise the following query, it's doing a Clustered Index Scan (Clustered).

select document.DocumentID as 'document.document.id',

document.DocFolderID as 'document.document.folderID',

document.FileName as 'document.document.description',

document.FileSize as 'document.document.fileSize',

document.ModifiedDate as 'document.document.modifiedDate',

document.TableName as 'document.document.tableName',

document.EntityCode as 'document.document.entityCode'

from...

below86 (1/20/2016)

---

You could use something like this to just find the max date of those columns, it won't get you the column name though. I found this on another...

abdellahmoh2016 (1/20/2016)

---

HI ALL

I'm new in T-SQL so i need your help

My problem is : After deleting a row , is there a way to retrieve the ID of that row...

Jacob Wilkins (1/20/2016)

---

If all we care about is the max date for each ID, it should be close between those and the CASE, if the CASE version is also modified...

Lynn Pettis (1/20/2016)

---

Brandie Tarvin (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything...

Phil Parkin (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently...

GilaMonster (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

Alan.B (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length....

Ed Wagner (1/19/2016)

---

Thanks, Eirikur. Yes, there are many approaches to getting the...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

Ed Wagner (1/20/2016)

---

I love the internals stuff. I'm currently reading SQL Server 2012 Internals by Kalen Delaney. If anyone's looking for good stuff on the internals, it's one...