Viewing 15 posts - 57,571 through 57,585 (of 59,048 total)
Hmmm.... the code is NOT exactly the same... you added .Txt to the file name and messed up on some spacing (ie. BCP SET came out as BCPSET in your...
September 20, 2006 at 7:52 pm
DOD eh? Haven't they heard of ISO standards for data? Sheesh! Where's Joe Celko when you need a good rant from him?
...
September 20, 2006 at 7:04 pm
Thanks Mita... I learn something new everytime I do something like this, so thanks for posting the problem.
Lemme know how long it takes to do the 14 million rows... I'm...
September 20, 2006 at 5:42 pm
I'll try running the code you posted back when I get home from work, tonight. Looks identical... dunno by more than casual glance why you are getting the BCP error...
September 20, 2006 at 8:13 am
I never ask that question because the answer is usually something that raises my hackles
It's usually ok for Developers to have read...
September 20, 2006 at 7:59 am
Ok... now I get to accuse you of reading minds...
My only distain for that is if you are comparing two or more...
September 20, 2006 at 7:50 am
It's too bad that functions don't work like sprocs do when it comes to defaulting inputs so that we could make this function a little wider without having to insert...
September 20, 2006 at 12:06 am
Yep... could be done that way and, as usual, is very easy and yet creative on your part. I was thinking something similar but I was really intrigued by the math...
September 19, 2006 at 11:31 pm
Ok... here 'tis... should be at least 30 times faster
because it only produces the internal rows it needs for the...
September 19, 2006 at 11:11 pm
Tim,
Do you have a "MinOfTwo" function for a fellow "CASE Adverse" compatriot?
September 19, 2006 at 8:44 pm
I'm thinking about it by why just a single query? Hopefully, you're not going to create a view of this monster...
.
I have an...
September 19, 2006 at 7:50 pm
So you were just kidding when you wrote the following? ![]()
| During... |
September 19, 2006 at 7:36 pm
Shouldn't have to because the server should be able to see it's own drives. Dunno what's wrong because the code I wrote works fine on my server.
Also, dunno what...
September 19, 2006 at 6:04 pm
Viewing 15 posts - 57,571 through 57,585 (of 59,048 total)