Viewing 15 posts - 53,971 through 53,985 (of 59,065 total)
Roger that... fix is simple... same code except where highlighted... will take care of up to 16 spaces between elements...
SELECT s.RowID,
Type...
November 23, 2007 at 3:44 pm
Heh... I'd normally agree, but I can't buy that one in this case, Brian. Unless the company puts crack in the coffee machines, they're not going to give the...
November 23, 2007 at 3:33 pm
Heh... that's better... thanks, Brian.
November 23, 2007 at 3:26 pm
Brian is correct...
Yes... you can copy and register just the two BCP files. But, it's against the law and it breaks the licensing agreement. Microsoft does NOT...
November 23, 2007 at 12:04 pm
Maybe the new security features for parts of the server that point to the outside world and the fact that MS won't support 2k soon are worth it... but most...
November 23, 2007 at 11:59 am
Sure, you can use a cursor or while loop to perform such a feat...
But that also means you're doing one of the worst things possible in any RDBMS... you're programming...
November 23, 2007 at 11:48 am
Do you have any triggers on the target tables? It's important...
November 23, 2007 at 11:43 am
There were no spaces in your original sample data. If that continues to be a problem, let me know... the fix is simple...
November 23, 2007 at 11:36 am
The code I posted extracts all three fields even for the "01" records...
You didn't even try the code, did you?
November 23, 2007 at 11:12 am
Why are you still fighting this problem, Ray? I gave you an answer and code that resolves all of these problems last night...
http://www.sqlservercentral.com/Forums/Topic425054-149-1.aspx#bm425122
November 23, 2007 at 11:10 am
Heh... good point, Brian. And, (I forget who said it) sometimes you must unlearn what you have learnt in order to find and fix a problem.
But, I believe the...
November 23, 2007 at 11:05 am
Heh... and there's another good example... words like "spelt" and "learnt" may be good and proper words in "European English"... it the U.S.A., they are more correctly written and pronounced...
November 23, 2007 at 4:59 am
DATETIME is really a FLOAT in the background (although it is a "fixed point float", if you can imagine that). DATETIME uses the same BINARY math as FLOAT.
November 23, 2007 at 4:47 am
Sounds like some of the other "Senior Software Engineers" I've interviewed... and rejected :Whistling:
November 23, 2007 at 1:05 am
Haven't tried it in a view before... you must either create a Linked Server or use OPENROWSET or OPENDATASOURCE.
November 22, 2007 at 9:37 pm
Viewing 15 posts - 53,971 through 53,985 (of 59,065 total)