this article may give you some pointers

http://www.sqlservercentral.com/articles/T-SQL/88244/

try this

SELECT LID

FROM TEST_TABLE_Dupe_Pay

GROUP BY LID

HAVING DATEDIFF(d, MIN(DraftDt) , MAX(DraftDt)) <=3

SQLPain (10/20/2015)

---

Hello everyone, is it possible that result set only return me the Loan ID (LID) where my Draft Date (DraftDt) is within 3 days to each other, for example...

sreeya (10/20/2015)

---

The same Customer may purchase multiple times on the same day plus we have about 100 millions of active users. As I said facts table is pretty big with...

Good resource can be found here by Jeff Moden

http://www.sqlservercentral.com/articles/Test+Data/88964/

DECLARE @NumberOfRows INT,

@StartDate DATETIME,

...

to start with....does this work?

WITH CTE

AS (SELECT

*

...

malcolm.garbett (10/18/2015)

---

Hi,

Hope I'm posting in the correct area.

I have a table with constantly changing data - stock.

I want to start monitoring the value of stock at the end of each...

based on the latest sample data....what results are you expecting?

please provide details

havent you asked this type of question before?

http://www.sqlservercentral.com/Forums/FindPost1719078.aspx

LeeFAR (10/7/2015)

---

I have a challenge and I'm not sure the best route to go. Consider the following dataset.

I have a table of sales. The table has fields for...

maybe....

CREATE TABLE #sampledata(

StrId INTEGER NOT NULL PRIMARY KEY

,PersId INTEGER NOT NULL

,percentId...

??... does it work for you ...??

....not entirely sure that I understand your requirements....but try this

CREATE TABLE #sampledata(

PersonID int NOT...

excuse me,...

ChrisM@Work (10/5/2015)

---

TomThomson (10/3/2015)

---

ChrisM@Work (10/1/2015)

---

Gosh David you must be an old git...