Forum Replies Created

Viewing 15 posts - 56,866 through 56,880 (of 59,067 total)

  • RE: Bulk insert data conversion error (truncation) for row 1001

    >>Bulk insert data conversion error (truncation) for row 10001

    That error has nothing to do with the batch size... it has everything to do with the column size of your target...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 26, 2007 at 7:29 pm

    #691942

  • RE: UPDATE from two tables

    Oh no, no, no... not true... check Books Online... every single example where a join is involved has the target of the update in the FROM clause, as well.  In...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 26, 2007 at 7:23 pm

    #691941

  • RE: Workday calculations

    Like I said... make a function using the SELECT examples I gave... then just do a joined select and use the function passing the date from one table...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 26, 2007 at 7:08 pm

    #691938

  • RE: NULL Equals NULL?

    Mike C,

    Man, nice job.  I absolutely agree with Tim's assesment of the "AA" he speaks of.  The real fact is "NULLs Happen" ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 26, 2007 at 8:28 am

    #691782

  • RE: NULL Equals NULL?

    Speaking of "no clue"...

    select(field1) + sum(field2) from #table1

    ... will yield ...

    Server: Msg 8118, Level 16, State 1, Line 1

    Column '#table1.field1' is invalid in the select...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 26, 2007 at 8:19 am

    #691776

  • RE: The Best Thing?

    I just love the fact that there's an average of more than 16 bytes of structure for every byte of actual data   It's...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 26, 2007 at 12:16 am

    #691664

  • RE: Workday calculations

    Lot's of folks will do a calculation like this...

    --===== A way without the WorkDayCountColumn

    SELECT c.Date

        FROM #Calendar c

        WHERE

            c.IsWorkDay = 1

        AND 4+1...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 25, 2007 at 11:19 am

    #691627

  • RE: Workday calculations

    I see you're online right now, Jeremy... gimme a couple minutes more and I'll show you one way to do this...

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 25, 2007 at 10:49 am

    #691626

  • RE: Row number

    quoteI want to avoid temp tables..trying to get in a simple select if possible from system functions.

    Can you...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 23, 2007 at 10:41 pm

    #691600

  • RE: Alter Table

    So, basically, it's a data model change with a cleanup script to boot and not a permanent stored procedure?

    If that's true, then just add a GO on a separate line...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 21, 2007 at 5:21 pm

    #691049

  • RE: Calc Highest and Lowest

    Thanks, SW...

    Peter is correct, though... if all of the values for a given account number are <= 0, the account won't print (dunno if you want that or not).  Peter's...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 21, 2007 at 5:10 pm

    #691047

  • RE: Urgent performance problems

    Sam,

    You took a good first step by defragging the DB.  Now, about that "slow query" and "insufficient memory" problem... "slow" normally means "resource hog" for CPU, IO, and Memory.  If...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 20, 2007 at 8:31 pm

    #690801

  • RE: How long would you prep for Exam 70-431 (MCTS)?

    I believe the training kit will give you a good idea... wait for the training kit before you book the exam...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 20, 2007 at 8:07 pm

    #690799

  • RE: Calc Highest and Lowest

    This should do it...

    --===== Setup a table to test with

     CREATE TABLE #MyHead (AcctNo VARCHAR(10), Month1 INT, Month2 INT, Month3 INT)

     INSERT INTO #MyHead (AcctNo, Month1, Month2, Month3)

     SELECT 'A',  -1,  ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 20, 2007 at 8:05 pm

    #690798

  • RE: Read Data From Table :: Find Files :: Print Files - How?

    Since you're trying to print a PDF file, is Acrobat Reader or a print driver for PDF's installed on the server?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    February 20, 2007 at 7:51 pm

    #690796

Viewing 15 posts - 56,866 through 56,880 (of 59,067 total)