Hi Peter,

Could you help me understand why

14 bbbb 13

15 bbbbb 14

16 bbbbbb 15

are not in the result set and why the result set stopped at

13 bb 0

I guess this might help

SELECT cast (round(11.63,1) as numeric(12,1))

/*Replace your column name instead 11.63*/

This question is more of like traversing to the next record from a cycle.

Hi Experts,

There would be a better solution then , the one mention above by me.

If some body has it would be great to know. Just to improve on my own....

I tried a little bit on solution and got it right :w00t:

So here is the code

SELECT t.UserName, t.Drink, t.CreatedDate, x.Value

FROM #TEMP t

OUTER APPLY (

SELECT TOP 1 Value

FROM

(

--SELECT *...

Hi Eirikur,

🙂 your example was a good learning , Thanks.

Mr.Eirikur , Do you know some good article which are good to understand Grouped Set, Of Course google is present ,...

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 consider the first group...

I would once again like to thank you Chris , thanks for taking out the time and helping me.

Hi Chris,

I Thank you for taking time out and answering my question.

Actually i was thinking of tweaking the result set little bit, but i was not able to come...

Hi Experts ,

I am not able to come up with the logic for making them (Catch Out/HitWicket to LBW) as one group and then perform the operation(take the strike...

ChrisM@Work (8/7/2014)

---

Shadab Shah (8/7/2014)

---

ChrisM@Work (8/7/2014)

---

Should be easy enough - but as Lutz pointed out, which column will you use for the sequence? Without one, there's no concept of "earlier" or...

ChrisM@Work (8/7/2014)

---

Should be easy enough - but as Lutz pointed out, which column will you use for the sequence? Without one, there's no concept of "earlier" or "later". Did you...

Thanks Chris for the reply and your time.

Since yesterday i am trying to improvised on the solution given by you.

Actually there is one more condition , Consider the below

CREATE...

Hi Steve,

I am newbie and might be wrong but even though Cube is not process or has failed to process, i should be able to see and access the...

Ok. Got it. Actually i happen ,not to see your link which you had posted.

Thanks for your time Koen 🙂