David Burrows

Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 3,544 total)

RE: DTS a text file into SQL Server

Are you transferring the data as fixed or delimited?
Far away is close at hand in the images of elsewhere.
Anon.

September 12, 2003 at 7:33 am

#473920
RE: Language & Date format

Try checking the default language for the logins. Set to 'English' in EM which equates to 'us_english' language in sysxlogins.
I have found 'British English' equates to 'British' in sysxlogins and...
Far away is close at hand in the images of elsewhere.
Anon.

September 12, 2003 at 7:24 am

#473918
RE: bcp a view with a large number of rows

I'm using SQL7 SP4 and can bcp a table with 557 columns with no problems.
Can only think that it either a problem with data or datatypes.
Far away is close at hand in the images of elsewhere.
Anon.

September 12, 2003 at 7:16 am

#473914
RE: DTS a text file into SQL Server

Before finding a solution you need to find what the problem was. Is it possible that the row in question had additional non printable character(s) or extra LF which was...
Far away is close at hand in the images of elsewhere.
Anon.

September 12, 2003 at 3:51 am

#473876
RE: Multiple TOPs

In another thread somewhere I posted a solution for this type of problem that used a temp table instead of cursor. I basically
Created a temp table (Store,Department,Amount,idno) order by
Store...
Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 8:22 am

#473731
RE: BCP with Format???

Does your network/security allow one of the sql 2000/7.0 servers to access the 6.5 server, if so than you can use DTS to retrieve data from the 6.5 server.
Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 8:09 am

#473728
RE: QOD 11 Sep 2003

ErikBr,
quote:
It seems to become a habit to complain about the question if one had it wrong.
Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 8:04 am

#473727

RE: BCP with Format???

Is 6.5 the only version you have?

Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 6:03 am

#473682

RE: What did you do before SQL?

HI Frank,

quote:
Btw, I also insisted on this slight difference between a programmer and a software engineer

Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 4:32 am

#473659

RE: QOD 11 Sep 2003

Yes a good question and I got it wrong. I originally was going for 3 but changed my mind (doh! ). I went for 4 as in...

Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 4:19 am

#473655

RE: How to run dynamic SQL with IF EXISTS?

From my understanding and what I remember from other threads on this site, you are correct. IF EXISTS will stop at the first successful match. How long it takes will...

Far away is close at hand in the images of elsewhere.
Anon.

September 11, 2003 at 3:26 am

#473638