<div>
;WITH CTE AS (<br />
SELECT<br />
&nbsp; &nbsp;ContactID<br />
&nbsp; &nbsp;,ProgramTypeID<br />
&nbsp; &nbsp;,ReceivedDate<br />
&nbsp; &nbsp;,ROW_NUMBER() OVER (Partition By ContactID, ProgramTypeID ORDER BY ReceivedDate DESC) RN<br />
FROM <br />
&nbsp; &nbsp;Application<br />
)<br />
<br />
SELECT <br />
&nbsp; &nbsp;*<br />
FROM<br />
&nbsp; &nbsp;CTE <br />
WHERE<br />
&nbsp; &nbsp;RN = 1
</div>


;WITH CTE AS (
SELECT
   ContactID
   ,ProgramTypeID
   ,ReceivedDate
   ,ROW_NUMBER() OVER (Partition By ContactID, ProgramTypeID ORDER BY ReceivedDate DESC) RN
FROM
   Application
)

SELECT
   *
FROM
   CTE
WHERE
   RN = 1

<div>
I ended up using this query as it was easier to understand and gave the results I was expecting. <br />
<br />
Thanks!
</div>


I ended up using this query as it was easier to understand and gave the results I was expecting.

Thanks!

<div>
<div class="content wysiwyg-content">
Hello experts, <br />
<br />
I have this table structure <br />
<br />
Application<br />
ID, ContactID, ProgramTypeId, ReceivedDate, OtherMetadata<br />
<br />
I want to get only the most recent ReceivedDate for a given ContactID, ProgramTypeId combination. <br />
<br />
Let me know if you would like me to add sample data.<br />
<br />
Thanks!
</div>
</div>


Hello experts, 

I have this table structure 

Application
ID, ContactID, ProgramTypeId, ReceivedDate, OtherMetadata

I want to get only the most recent ReceivedDate for a given ContactID, ProgramTypeId combination. 

Let me know if you would like me to add sample data.

Thanks!

Grouping SQL Server Query Question

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.