mickyT (11/14/2013)

---

I'm not sure if I am understanding the requirements for this correctly, but would this work?

declare @cellid int = 1;

select *

from CellAxes c

inner join (

select cellid

from (select axiscode, positiononaxis...

Laurence Neville (11/14/2013)

---

I now have the result I need. I combined your approach with someone else's help on StackOverflow and came up with this:

declare @CellID int = 1

;with SelectedCell as

(

select...

Perhaps you can explain how you expect to "condense" overlapping periods in ID=1 from 5 rows to 6 rows (sample data vs. expected results)?

Gosh! That bad, huh? Guess you can't win them all.

They call this the Asian Unicorn.

There now. We've...

Glad to be of service!

wolfkillj (11/13/2013)

---

Ed Wagner (11/13/2013)

---

Greg Edwards-268690 (11/13/2013)

---

venoym (11/13/2013)

---

L' Eomot Inversé (11/12/2013)

---

wolfkillj (11/12/2013)

---

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging me...

As you appear to be using SQL 2012, have you looked at using the LAG function to solve this?

It would probably be a lot faster than what you settled on.

Lowell (11/13/2013)

---

take a look at this thread, where there's a couple of different ways the same problem was tackled:

Large String Value needs to be broken down into Human readible fixed...

lmeinke (11/13/2013)

---

Dwain,

I did remember to cast to varchar but may not have matched the actual length of varchar in the table. Can you tell me why this exact match would...

Mitzy - You are lucky! I almost missed this in the flood of response emails I got last night.

This probably isn't perfect but may give you an idea.

DECLARE @sql...

autoexcrement (11/13/2013)

---

Wow, I never in a million years would have been able to interpret the data in that way. I still don't exactly understand how you were able to see...

WITH NewBOM AS

(

SELECT MODEL=COMPONENT_ITEM, [OPTION]=PARENT_ITEM

,[LEVEL], LEVEL_INDENTED, COMPONENT_ITEM, PARENT_ITEM, ITEM_TYPE

,[SORT]=CAST([LEVEL]...

autoexcrement (11/13/2013)

---

Can someone please help me to catch up? I feel I'm not understanding the issue. Using the OP's initial data:

ITEM1 ITEM2 ID

0224180 0224181 1

0224180 0224190 1

0224181 0224180 1

0224181 0224190...

lmeinke (11/13/2013)

---

Correction....those errors were due to my sloppy typing....but back to the original error:

Msg 240, Level 16, State 1, Line 1

Types don't match between the anchor and the recursive part...