<div>
Can you please provide few input rows.
</div>


<div>
Hey Pawan...<br />
Figured it out I think...<br />
<br />
Can you review this ?<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42393317-1"><span>SELECT m1.MessageID,</span>
<span>       m2.MessageID,</span>
<span>       m2.IndividualID ,</span>
<span>       m2.MessageText ,</span>
<span>       m1.DateAdded ,</span>
<span>       m2.DateAdded</span>
<span>FROM   ewMessages m1</span>
<span>       INNER JOIN ewMessages m2 ON m2.IndividualID = m1.IndividualID</span>
<span>                                   AND m2.MessageText = m1.MessageText</span>
<span>WHERE  m1.SalesSiteID = 103887</span>
<span>       AND m1.MessageID &lt;&gt; m2.MessageID</span>
<span>       AND CAST(m1.DateAdded AS DATE) = CAST(m2.DateAdded AS DATE)</span>
<span>       --Change the difference in minutes to widen scope</span>
<span>       AND m2.DateAdded &lt;= DATEADD(mi, 2, m1.DateAdded);</span>
</code></pre>
<br />
Example output is...<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/12_w49/1213921/sp.png" target="_blank" title="Screen Print (29 KB)"><img alt="Screen Print" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/12_w49/800_1213921/sp.png" /></a>
</div>


sp.png

<div>
DECLARE @minute_range int<br />
SET @minute_range = 2 /*adjust if/as needed*/<br />
<br />
SELECT m1.MessageID,<br />
&nbsp; &nbsp; &nbsp; &nbsp;m2.MessageID,<br />
&nbsp; &nbsp; &nbsp; &nbsp;m2.IndividualID,<br />
&nbsp; &nbsp; &nbsp; &nbsp;m2.MessageText,<br />
&nbsp; &nbsp; &nbsp; &nbsp;m1.DateAdded,<br />
&nbsp; &nbsp; &nbsp; &nbsp;m2.DateAdded<br />
FROM &nbsp; ewMessages m1<br />
&nbsp; &nbsp; &nbsp; &nbsp;INNER JOIN ewMessages m2 ON m2.SalesSiteID = 103887 /*optional, remove if not wanted*/<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND m2.MessageID <b>&gt;</b> m1.MessageID<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND m2.IndividualID = m1.IndividualID<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND m2.MessageText = m1.MessageText<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND m2.DateAdded &gt;= m1.DateAdded<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND m2.DateAdded &lt;= DATEADD(MINUTE, @minute_range, m1.DateAdded) <br />
WHERE &nbsp;m1.SalesSiteID = 103887
</div>


<div>
Sorry Scott<br />
Saw it late but thanks
</div>


<div>
<div class="content wysiwyg-content">
I need to search a table <br />
UID &nbsp; &nbsp;IndividualID &nbsp; &nbsp; &nbsp;MessageText &nbsp; DateAdded<br />
<br />
Where there are duplicate records on IndividualID and MessageText within 5 minutes of each other
</div>
</div>


I need to search a table 
UID    IndividualID      MessageText   DateAdded

Where there are duplicate records on IndividualID and MessageText within 5 minutes of each other

SQL Server possible dupe record

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Remote access may refer to the connection to a data-processing system from a remote location, for example through a virtual private network remote desktop software, terminal emulation, or the activation of features of a business telephone system from outside the business's premises.