Hi,

Thanks for looking into my question. I am rephrasing my question to make you to understand

How to use TFS , to manage...

Tons of Thanks to you , in fixing and finding solution . But I am not sure , how it works on production data . As of now ,...

Hi ,

MAX(Syskey) is not required . I made it , when i was doing hit and trail .

Thanks

Surya Sunil

Hi ,

Thanks for looking into post .

Dates are integer in the upstream , which I need to consolidate for Datawarehouse purpose .

Is this possible solution at high Level . PFA

:crying:

Actually , I simplified problem .. coming to real scenario ...

Task A getting hanged ( Could not able to sort out...

Solution is fine . The other scenario will not arise which i clarified from business ..

Yes you are right

Cake can have x steps and it depends on customer request .. Once work flow starts it starts with 1 and reaches nth step...

Hi Doshan ,

Query is working as expected ... Number of intermediate Steps in delivery of cake will vary . So ...

I have provided expected output as 2nd snapshot (as a picture) in first thread itself . Let me know whether snapshot is available ...

Consider CakeID as something like OrderID from customer . If Cake is rejected ,again bakery start from Baking but CakeID remains Same but New batch...

Thanks Chris ...

The solution is as expected.. but need to check performance .

Thanks

Surya Sunil

Output should be like that as I mentioned ...

So that we know between what dates , the bus was used ..