I don't think this is a case of either one does or doesn't, however being immersed in it does help. I don't do these types of things daily in...

No problem ... glad to help

autoexcrement (11/13/2013)

---

I'm trying to wrap my head around this and would appreciate some plain-English explanation if anyone feels up to it. I'm trying to work from the inside out, and...

Hi

Firstly you need some way to order the rows by, so I've added the seq column to order on. Then it is basically a find the islands query. ...

Especially...

Kyr_Soronas (11/12/2013)

---

mickyT (11/12/2013)

---

LutzM (11/12/2013)

---

@Kyr_Soronas: I though about an approach towards what mickyT came up with, but just without the "fancy geometry stuff" (@mickyT: no offence intended 😉 )

However, instead of...

LutzM (11/12/2013)

---

@Kyr_Soronas: I though about an approach towards what mickyT came up with, but just without the "fancy geometry stuff" (@mickyT: no offence intended 😉 )

However, instead of using computed...

Hi

I was thinking geometry, but that would be overkill :-). Another option would be to add some calculated columns for minx, maxx, miny and maxy.

Having a look at the...

Hi nhimabindhu

Looking at the procedure that you posted, I think this is what you are trying to do.

Note that I am using the DelimitedSplit8k[/url] function previously mentioned.

Create PROCEDURE [dbo].[USP_UpdateGroupAccess](

@VALUE VARCHAR(8000),...

Jeff Moden has an excellent splitter here[/url] that performs extremely quickly. Once you have that, you can do the following

select rowseq,

min(col1) item1,

min(col2) item2,

min(col3) item3,

min(col4) item4,

min(col5) item5,

min(col6) item6

from (

select ps.itemnumber...

Thanks ... inspired by others (Jeff) of course:-)

Just realized that I was reading the dates the wrong way.

Will edit my previous to fix

Hi

If you have a look at this article[/url] by Jeff Moden, it will explain how to group by contiguous islands of dates. This is essentially what you are trying...

Sorry I accidentally replied, was going to mention to watch out for underscores as well

I'm annoyed that I didn't read the question properly first up and over complicated it in my first reply:-)