Forum Replies Created

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

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

    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.

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

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

    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.

    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.

    September 11, 2003 at 8:04 am

    #473727

  • RE: BCP with Format???

    Is 6.5 the only version you have?

    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

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

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

    September 11, 2003 at 3:26 am

    #473638

  • RE: What did you do before SQL?

    David,

    quote:

    Still doing the impossible for the ungrateful.

    Hey you doing my job

    September 11, 2003 at 3:06 am

    #473636

  • RE: How to run dynamic SQL with IF EXISTS?

    Still not clear

    Why 'WHILE 1 = 2' this means the code is never actioned

    quote:

    I have a loop which will capture a...

    September 10, 2003 at 9:04 am

    #473449

  • RE: How to run dynamic SQL with IF EXISTS?

    Can you post your query

    September 10, 2003 at 6:49 am

    #473403

  • RE: UDF in sqlserver 7.0

    Without more specifics it's difficult not to generalize.

    The view option will work but could be inneficient if there are more than 4 tables and/or a lot of rows.

    I would do...

    September 10, 2003 at 6:44 am

    #473402

  • RE: Search &Replace with ntext columns

    Variation of above with a loop. You can wrap this in a proc and pass text.

    CREATE TABLE #temp (rowid int,textcol ntext) 

    INSERT INTO  #temp...

    September 10, 2003 at 3:15 am

    #473368

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