Well if it was not for the VB of the 90's I would not have been a programmer today.

So certainly, if you look on the flip side of your coin,...

I will have to run with this. Thanks!! Appreciate the feedback.

Awesome!!!!! Thanks for sharing this knowledge!!!

I've been pondering this for a while now. Especially with my interest in Neural Networks as well.

Perhaps the performance can be improved by implementing an...

GSquared (7/22/2011)

---

1 second per row is too long. 200k records at 1 second per row is a bit over 55 hours. Just so you have the right scope...

Gianluca Sartori (7/22/2011)

---

I don't think so, unless you're really using SQL Server 2000 (is this the right forum?).

Take a look at these articles and see if they help:

Displaying Sorted Hierarchies[/url]

Hierarchies...

Yes!

Thanks a mil for that!!!

I've got another cursor running on our live system with

"No other way"

But that is low priority, and I might turn addressing that issue into an...

Ok Sorted now

I excluded the rows that caused the error, and found the results still a bit big, so I aimed at compressing the data even more. I then decided...

OK, so Now a curve ball was dealt.

Not all part numbers follow the same format.

As in my sample, most parts has the format:

00000-000-000

I just came across some partnumbers that crash...

Jeff! You are my hero. Will go through it again, but I think i got most of it.

I simply love the force error part...

ELSE 1/0

and #MyHead... very creative 😉

mister.magoo (2/25/2011)

---

ZA_Crafty (2/24/2011)

---

mister.magoo (2/24/2011)

---

Try this:

select Factor,min(PartNumber) as PartFrom,max(PartNumber) as PartTo

from Factors2Process

group BY Factor,stuff(PartNumber,7,5,'')

order by Factor,PartFrom

And by the way - there is no order by on the query in your...

mister.magoo (2/24/2011)

---

Try this:

select Factor,min(PartNumber) as PartFrom,max(PartNumber) as PartTo

from Factors2Process

group BY Factor,stuff(PartNumber,7,5,'')

order by Factor,PartFrom

And by the way - there is no order by on the query in your cursor definition...you...

Ok this is what I did.

Let see if we can find some cleaner solutions.

I for one still use cursors in these type of scenarios, but only because I'm not aware...

I have a solution in mind, but would like to see first if there is an alternative.

I can add an extra column to the table. say (seq int null)

Then Create...

Sorry, just noticed that. That was a bit of actual data that got mixed up in sample data.

Thus the output should be:

SELECT '0.2293830000' As 'Factor'

,'11400-95855-000' as 'PartFrom'

,'11400-95857-000' as 'PartTo'

UNION SELECT...

It actually does make sense...

20/20 Hindsight vision 🙂

If you create a custom user control in c#, you need to do a build of the app for the new methods...