karthikeyan (11/22/2007)

---

if nobody working for this site ,then how the databases are maintained ?

Really i dont know can you tell me how does this site is running ? Atleast they...

So long as they don't change it to decimal math... that would just slow it down 😀

Is this the constraint that you cannot delete?

if exists (select * from dbo.sysobjects where name = 'FK_tdta_ebMatrix_tkey_eBaum')

ALTER TABLE [dbo].[tdta_EntscheidungsbaumMatrix] DROP CONSTRAINT FK_tdta_ebMatrix_tkey_eBaum

GO

If so, what happens when you manually run the...

Roger that... fix is simple... same code except where highlighted... will take care of up to 16 spaces between elements...

SELECT s.RowID,

Type...

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...

Heh... that's better... thanks, Brian.

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...

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...

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...

Do you have any triggers on the target tables? It's important...

There were no spaces in your original sample data. If that continues to be a problem, let me know... the fix is simple...

The code I posted extracts all three fields even for the "01" records...

You didn't even try the code, did you?

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

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...

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...