Forum Replies Created

Viewing 15 posts - 36,736 through 36,750 (of 59,072 total)

  • RE: XML "CSV" Splitter

    Yep... sorry, Peter. I meant to say that I tested that method, as well. It's not nearly as bad as the original dot version but, you're correct, 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)

    September 17, 2010 at 6:18 am

    #1222917

  • RE: Using a common seed generation for multiple tables.

    I'm curious... Why do the folks that imposed this requirement think that it's a good idea to do?

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

    September 16, 2010 at 10:01 pm

    #1222729

  • RE: Query help -employee

    SSISLearner (9/16/2010)

    Is there any way to get this list from a single query using CTE's.

    The query that Wayne wrote will certainly do the "single query" thing correctly. Just be...

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

    September 16, 2010 at 9:57 pm

    #1222727

  • RE: Replace the Null values

    laddu4700 (9/16/2010)

    Actually I need to export the data to excel file. Some the coulumns data have NULL values.

    I have used ISNULL function and wrote a below T-SQL statement, but...

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

    September 16, 2010 at 9:46 pm

    #1222724

  • RE: Replace NULL with empty space.

    laddu4700 (9/16/2010)

    I am trying to export the SQL Server 2005 database tables(10) to csv files.

    But some of the tables columns data have NULL values. I need to replace the NULL...

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

    September 16, 2010 at 9:44 pm

    #1222723

  • RE: Servidor vinculado

    SysEdw (9/16/2010)

    hola un favor estoy intenando hacer una consulta de dbf por medio de sql 2008 (analizador de consulta) y me sale el error, no se que mas me falta...

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

    September 16, 2010 at 9:40 pm

    #1222722

  • RE: INNER JOIN CHALLENGE

    Derrick Smith (9/15/2010)

    Ah crap, I did. Didn't even notice that. Hard to follow the logic of this query..working on it.

    BWAA-HAAA!!! You have to learn to roll the "R" 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)

    September 16, 2010 at 9:38 pm

    #1222720

  • RE: INNER JOIN CHALLENGE

    Mike01 (9/15/2010)

    For clarification, you should use the 3 part naming convention on all tables (when crossing databases like this), just so someone down the road will know where they are...

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

    September 16, 2010 at 9:36 pm

    #1222719

  • RE: Ordinal Dates

    Probably the best thing to do would be to make a "helper table" with the numbers 1 to 31 in it and the character ordinals. Then, use the 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)

    September 16, 2010 at 9:29 pm

    #1222717

  • RE: XML "CSV" Splitter

    Wow... I guess my machine doesn't like XML so much. I stopped the test after 10 minutes on a 10K by 100 run.

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

    September 16, 2010 at 7:21 pm

    #1222708

  • RE: XML "CSV" Splitter

    Peter Brinkhaus (9/13/2010)

    I am not an XML Ninja either, but you can try a inline table valued function

    CREATE FUNCTION dbo.Split8KX_Inline(@Parameter VARCHAR(MAX), @Delimiter VARCHAR(1))

    RETURNS TABLE

    WITH SCHEMABINDING

    AS

    RETURN

    ...

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

    September 16, 2010 at 6:58 pm

    #1222703

  • RE: XML "CSV" Splitter

    Brad Schulz (9/16/2010)

    Jeff,

    Here's the key to the mystery as to why you and I get differing results.

    All of my tests included compile time also, because I did a DBCC FREEPROCCACHE...

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

    September 16, 2010 at 6:56 pm

    #1222702

  • RE: Are the posted questions getting worse?

    Paul White NZ (9/16/2010)

    GilaMonster (9/16/2010)

    Steve Jones - Editor (9/16/2010)

    What's humour? You hanging out with Brit's in TN?

    He's finally learnt to spell properly. 😀

    Perhaps a course on the correct use...

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

    September 16, 2010 at 2:47 pm

    #1222626

  • RE: Raw Materials - The Decision

    Steve Jones - Editor (9/16/2010)

    I was told recently that the Raw Materials comics that we have run for a little over a year, will be be discontinued recently. This wasn't...

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

    September 16, 2010 at 2:25 pm

    #1222596

  • RE: Raw Materials - The Decision

    gonickl (9/16/2010)

    I think it's interesting that the sheepization, I mean monetization proposals here were all based on making a tangible object, until I suggested a subscription model. People are so...

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

    September 16, 2010 at 2:02 pm

    #1222571

Viewing 15 posts - 36,736 through 36,750 (of 59,072 total)