Sean,

Thank you for the response. I've looked at the articles and I'll clean up the With (NOLOCK) statements. As stated in the articles I was placing these here...

OK I was able to resolve this issue by creating a Scalar function to concatenate the values I was looking for based on the fields I was using in my...

OK I am slowly getting closer to an answer, I think :crazy:. I can use the query below to concat the information I need into a dataset but...

Nope, "The Value expression for the textrun ‘AttrValue.Paragraphs[0].TextRuns[0]’ uses a RunningValue function in an outer aggregate. RunningValue...

Just to update you a bit I have tried to use the following code but it looks like the Last function in RunningValue is stopping when the row group value...

Not so sure that's a good idea for anything other than practice. If you did that in Bristol, RI, you're code would really be a problem because half of...

I wish I could post the query but I am not sure I have the right since it is part of a corporate application. The query I am using...

Yes you are correct. The definition of being rehired is that the first and last names are equal. If there are two rows where the names equal and the...

Yes you are correct, 11 are duplicated and a new record is created each time an employee is hired.

I was able to get the result set I wanted with the...

Sorry that doesn't work, the results set contains everything in my first query but it also contains all of the records from the DimEmployee table with Rehired set to 'N'...

Sorry that I confused you. My intent was to show my issue using a sample db since I am not able to send out information on my db. ...

Thanks for the suggestion but I am having trouble wrapping my head around the concepts. I used the AdventureWorks DB below to help illustrate my problem. But there...