Please post sample data and expected results as in the first link in my signature.

Generally, when you are trying to pull a single record from a group of...

Okay, I had an interview with a company that is doing a lot of work with SSIS 2012 and their main concern is that I have only worked with SSIS...

Here is a solution that only requires a single scan of the table.

;
WITH guids_ordered AS
(
    SELECT Id, FieldName,
        ROW_NUMBER() OVER(PARTITION BY Id ORDER BY...

Yes, I did blow up at someone on the forums.  I'm sure that the stress of being unemployed (and the consequent insomnia) played a role in this.

Drew

I think that the answer to this depends a lot on the process.  If the process is mostly asynchronous with some (synchronous) dependencies, then it may make sense to use...

Sorry, I posted before I actually added comments.

There were a couple of comments I had about Des' solution.

1. The main query should use your employee table.  This will...

Reported as spam.

You've been around long enough to know that's not the correct way to post data.

You said that this needs to be dynamic, but there is nothing about this...