<div>
nevermind, I see what you need now is the same thing but for all ProjectIDs at once, correct?
</div>


nevermind, I see what you need now is the same thing but for all ProjectIDs at once, correct?

<div>
Not quite .. I wish it was that easy<br />
.<br />
you are including a ProjectID filter , where I need ALL ProjectIDs<br />
.<br />
All ProjectIDs , not a single one<br />
.
</div>


Not quite .. I wish it was that easy
.
you are including a ProjectID filter , where I need ALL ProjectIDs
.
All ProjectIDs , not a single one
.

<div>
Tim_cs &nbsp;: &nbsp;Awesome quick SQL code
</div>


<div>
<div class="content wysiwyg-content">
I have a tricky problem I am trying to solve with either Multiple Views or perhaps a Procedure to create a temp table that is returned...<br />
.<br />
There is a Report that Shows the Last 5 comment entries for every Project<br />
.<br />
There is a table : &nbsp;tblFolderComments<br />
This table has fields :<br />
&nbsp; - &nbsp;FolderCommentID (Key)<br />
&nbsp; - &nbsp;ProjectID<br />
&nbsp; - &nbsp;FolderComment<br />
.<br />
.<br />
These Projects can have any number of comments from 0 to 20+<br />
<br />
I need to create something where I only get the most recent 5 [FolderComments] from each Project<br />
.<br />
I thought this was going to be simple ... but it has turned out not to be<br />
.
</div>
</div>


I have a tricky problem I am trying to solve with either Multiple Views or perhaps a Procedure to create a temp table that is returned...
.
There is a Report that Shows the Last 5 comment entries for every Project
.
There is a table :  tblFolderComments
This table has fields :
  -  FolderCommentID (Key)
  -  ProjectID
  -  FolderComment
.
.
These Projects can have any number of comments from 0 to 20+

I need to create something where I only get the most recent 5 [FolderComments] from each Project
.
I thought this was going to be simple ... but it has turned out not to be
.

SQL Server 2008 : Tricky Top 5 Rows Problem

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.