Paul, I am looking @ several million records. In each record is a nvarchar that IDs the record and a datetime for when the transaction took place for that nvarchar ID. I need to capture the nvarchar ID when a number of the records for that nvarchar ID was within a time period of the other records with the same nvarcharID. It seems that a cursor is the best way to go through each record to verify a count for the nvarchar ID each time the record was within (5) minutes of the original record. Would you have a set oriented method for extracting these sets of records?

USE TempDB
CREATE TABLE T1 (
        T1ID INT NOT NULL IDENTITY PRIMARY KEY,
        RecordID NVARCHAR(50) NOT NULL,
        TransTime DateTime NOT NULL
  )
GO
INSERT T1 (RecordID, TransTime)
    VALUES ('abc', '1/1/1980')
INSERT T1 (RecordID, TransTime)
    VALUES ('qwerty', '1/1/1980')
GO 3
INSERT T1 (RecordID, TransTime)
    VALUES ('abc', GETDATE())
INSERT T1 (RecordID, TransTime)
    VALUES ('qwerty', GETDATE())
INSERT T1 (RecordID, TransTime)
    VALUES ('qwerty', GETDATE())
INSERT T1 (RecordID, TransTime)
    VALUES ('xyz', GETDATE()) 
WAITFOR delay '000:000:000.050'
GO 25 

WITH FirstRecord AS
  (
  SELECT RecordID, MIN(TransTime) AS FirstTime
    FROM T1
    GROUP BY RecordID)
SELECT T1.RecordID, COUNT(*) AS COUNT
  FROM T1 
    JOIN FirstRecord
      ON T1.RecordID = FirstRecord.RecordID
      AND T1.TransTime <= DATEADD(n,1, FirstTime)
  GROUP BY T1.RecordID