Kevin,

Awsome! Thank you for the solution.

Mike

Jeff & Kevin,

Thank you for your input, it is much appreciated. As I am a rookie in SQL programming, the included code is so beneficial to learning what is...

Thanks SQLGuru for pointing me in the right direction. Taking your direction I worked on Row_Number and Partition By. This gets me ever so close to what I...

Here is a portion of the complete result set. I need the program to look at the curItem as compared to the prevItem and if there is a match,...

Sorry,

This would have made it much easier to understand. The resulting report should look like:

curItem / prevItem / Trnd

D ...

Jan Van der Eecken & L'Eomot Inverse'

Thank you for your time in answering my request and the clear direction.

In future posts I will follow forum protocol. Everyone's time is...

Steven,

Thank you for the reply it is much appreciated.

Mike

ChrisM

Thank you for the solution. I will give it a try.

Erin,

Thank you for your response. How do you chose the record before and after the record that is selected with this algorithm?

Mike

To ensure all of my data is complete.

Through further research I have found that the time represented by the "Client Execution Time" is the time in which the "Display Estimated Execution Plan" is ran. It is...

Thanks Jeff and Matthew,

I am using extremely large data sets (ie. 66,000,000 records). I will have to test both of these to see how fast they process through the...

Matthew Darwin & Gila Monster,

Thank you for your replies. Taking a solution as you recommended Gila Monster in SQL Server MVP Deep Dives, I have found a solution by...

Evil Kraig F,

Thank you for your reply. I will code this and see how it works. Aparently my solutions are too simple and as a result not working.

Mike

bitbucket,

Thank you for your reply. I will go read through this so that my postings are more efficient and revise what I posted.

Mike