Viewing 15 posts - 4,006 through 4,020 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 30, 2008 at 2:16 pm
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 30, 2008 at 1:28 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 30, 2008 at 10:57 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 30, 2008 at 9:32 am
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). ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 30, 2008 at 7:45 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 29, 2008 at 7:29 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 28, 2008 at 10:58 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 28, 2008 at 6:39 am
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?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 27, 2008 at 7:41 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 27, 2008 at 5:49 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 27, 2008 at 4:28 pm
Using the data at the bottom of this message, the CTE based code produces the following:
------------------------------------------------------------------------------------------------
3 5 ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2008 at 10:39 pm
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
------------------------------------------------
-- ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2008 at 5:06 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2008 at 2:04 pm
Thank you for the unsolicited advertisement.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 17, 2008 at 7:36 am
Viewing 15 posts - 4,006 through 4,020 (of 4,080 total)