StartDate is entered through application.

EndDate is something that is entered as Next(StartDate) - 1 day.

Like i said i am trying to used Leap and Lag function but what i am...

Hi John,

Goalpost moved again 🙂

Distinct would work fine for the small data set i have provided, but i am dealing with data with millions of rows and 50 column. Distinct...

Hey all,

Thanks for the response. But Left Join would not work in my case. I have updated the test data to represent my scenario very closely.

Any pointer on that would...

Thanks Erirkur for the help.

But i had miss quoted my question in previous screnario.

Thank u Cadavre for quick response.

I am sorry to pluzzel you with my requirement. But i thought of giving myself a day and try to come up with a solution...

Cadavre (9/4/2014)

---

JackTimber (9/4/2014)

---

Hi all experts,

I am sorry to post the problem of the same type , but i am not able to logically interpret how to traverse through the queries...

Guys,

Any link or reference 🙂

Thanks.

Naa re, its a different asignment. I am working by keeping ChrisM solution as a base from previous example, and lets see.

If i come up with a solution would definitely...

Actaully i was not able to come up with a solution for that problem, so the assignment was given to other guy. I had shown him this thread. He...

I tried figuring out that , but 🙁

Eirikur Eiriksson (8/23/2014)

---

Shadab Shah (8/23/2014)

---

Hi Eirikur,

I have being trying to help OP with this question with the help of your solution.

I think the grouping in your solution is incorrect.

If we...

JackTimber (8/23/2014)

---

Suppose if i decided to tweak my result as

/*

I want to traverse through a loop. Loop starts with Coke/Fanta and Ends With HardDrink.

After HardDrink it is neccessarily Coke...

Suppose if i decided to tweak my result as

/*

I want to traverse through a loop. Loop starts with Coke/Fanta and Ends With HardDrink.

After HardDrink it is neccessarily Coke or...

Thank you very much Chris.

Could i know your twitter handel, so that i can follow you.

Best Regards.

Hi Eirikur ,

Thanks for taking time out and replying.

Still i am not able to move forward.