Hi Wayne,

I completely appreciate what you said and that if i don't understand what it's doing then don't use it.

Your write-up and description however is really very helpful indeed. It...

WayneS (7/21/2015)

---

Ed Wagner (7/21/2015)

---

WayneS (7/21/2015)

---

What we need to do here is to look at the patterns.

The Length is from the first numeric value to the first non-numeric value.

The Width is...

Thanks a lot for the hasty reply.

I generated a table from a subset of the data i'm working with. I've attempted to attach it.

I'm currently having a read through the...

serg-52 (10/30/2014)

---

So try

SELECT DISTINCT

t1.id,

t1.empid,

t1.jobnum,

t1.opcode,

t1.starttime,

t1.finishtime,

t2.id id2,

t2.empid empid2,

t2.jobnum jobnum2,

t2.opcode opcode2,

t2.starttime starttime2,

t2.finishtime finishtime2

FROM

vGSL_DMTEpicorData t1 inner join

vGSL_DMTEpicorData t2

on t1.jobnum=t2.jobnum and

t1.empid=t2.empid and

(

t1.starttime < t2.finishtime and

t2.starttime...

serg-52 (10/30/2014)

---

Yep, overlapping condition ... Generaly, overlapping means

t1.starttime < t2.finishtime AND t2.starttime < t1.finishtime

i.e those intervals have at least one common point. And this condition is symmetric.

Sorry,...

Thanks for the hasty reply!

ID is indeed Unique but ID and ID2 could be the same because...