Tough crowd today....

Hey! I got the quote to work!

GIMME A BREAK HERE !! :w00t:

I was focused on showing the compromise solution to the duplicates only, since no one had any problems identifying the breaks. How...

No, if you look at the example 1 data in the compromise solution, 5 is code "C". Change it to "A" and it will show up.

Compromise Solution:

The following code uses set-based logic to get the set of all valid AND invalid duplicates within each 'A' range. It populates the @worktable table variable...

Seth:

;with cte1 as -- identify breaks

(select t1.RowID,t1.code

from #temptable t1

where t1.code <> (select top 1 code from #temptable where RowID < t1.rowID order by rowID desc)

)

This is only going to...

Guys, first let me make clear that I was pursuing a set-based solution purely out of curiosity for mental stimulation (like some people do crosswords or Sudoku puzzles). ...

Not that it matters at this point, but I have to recant my earlier belief that a set-based solution to this problem was possible. Set-based coding can produce...

I'm glad to see you guys finally slaying this beast 🙂 Wish I could have particpated more but I had to work on my personal performance...

Thanks for the reply, I believe I understand now. Regardless of the "why", this was an interesting problem to look at. If Anziobake's solution...

What if there were an additional row in your example?

SELECT 6,'2','en','A' UNION ALL

Include 5? Include 6? Include 5 and 6 both?

Hey Seth,

Could you give me one example of the iterative situation you describe. I didn't see that in all of the examples I looked at. If...

This thread is still going !!?!! I'm sorry to have missed all the fun, but I'm feeling lucky, so I'll try again. If the results are...

Using the data at the bottom of this message, the CTE based code produces the following:

------------------------------------------------------------------------------------------------

3 5 ...

Here's a set based solution using CTEs. Please let us see the execution plans and performance statistics when you have tested them. Best of luck.

Bob

------------------------------------------------

-- ...

One more question, are you trying to use INSERT INTO to create a table, rather than load an existing table??

INSERT INTO foo

SELECT...

FROM

does not...