Hi Jacob 

I am going mad here.

Any idea where i am going wrong in the below:
;WITH src AS (
SELECT (ID1 + ' -...

Its work system/database
Unlikely I would be able to but I will give it a shot.
Meanwhile if you don't know any other way, could you give me a demo...

Apologize, I will stick to the same forum.
Perhaps it was just my urgency/frustration which made me resort to posting in multiple places.
I am using 2012 but apparently only...

Hmmm I see, thats a brainier.
So let say for this example we change the N-Co date to prior 27th.

CREATE TABLE #temp
(
Identifier varchar(20)NOT NULL

Unfortunately the created date doesn't have a time stamp.
Given what you have in mind, what would the result look like given there is no timestamp to break the tie?

There is no particular order to the Statuses
It can be N-COMP before it is SENT or vise versa.
Its, a matter of ordering by completeddate column until it hits...

Hi
The status does, as that what I would like to roll it up to.
Make sense?
If not which scenario do you mean? I can elaborate.

Hi bmg002
Yeah the service number serves no purpose.
I appreciate your input...

Great, thank you!
Now one more thing, and please if you can be patient because that is the type of data set it is (limited) and this is the only type...

Thanks for responding 

But why is it counting 1 day if it should be from the min ( created) 20160729
until the 20160811 when the status is completed.

[code...