Reported as spam.

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.