Viewing 15 posts - 1 through 15 (of 47 total)
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,...
December 11, 2014 at 4:13 am
I will have to run with this. Thanks!! Appreciate the feedback.
May 30, 2014 at 12:51 am
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...
September 18, 2012 at 12:59 am
GSquared (7/22/2011)
July 22, 2011 at 12:43 pm
Gianluca Sartori (7/22/2011)
Take a look at these articles and see if they help:
July 22, 2011 at 12:02 pm
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...
March 11, 2011 at 6:14 am
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...
March 9, 2011 at 7:11 am
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...
March 9, 2011 at 6:15 am
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
February 27, 2011 at 2:11 pm
mister.magoo (2/25/2011)
ZA_Crafty (2/24/2011)
mister.magoo (2/24/2011)
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...
February 25, 2011 at 2:25 am
mister.magoo (2/24/2011)
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...
February 24, 2011 at 11:47 pm
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...
February 24, 2011 at 3:36 pm
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...
February 24, 2011 at 12:46 pm
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...
February 24, 2011 at 12:19 pm
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...
February 17, 2011 at 3:04 pm
Viewing 15 posts - 1 through 15 (of 47 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy