Forum Replies Created

Viewing 15 posts - 23,176 through 23,190 (of 59,099 total)

  • RE: Create SQL table from an Excel spreadsheet

    J Livingston SQL (7/20/2014)

    as an example of what may work for you...........

    I have a spreadsheet called JLS.xlsx that is always stored in C:\xlimport (C:\xlimport\jls.xlsx)

    it has a worksheet named "data"...

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

    July 20, 2014 at 9:56 am

    #1730865

  • RE: Create SQL table from an Excel spreadsheet

    pnr8uk (7/19/2014)

    Thanks for the reply and that is a good article, however it does not create the table automatically from the Excel spreadsheet. I can't create the table first as...

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

    July 19, 2014 at 9:08 pm

    #1730856

  • RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

    @Jeztagab,

    You're problem doesn't appear to be hierarchical in nature. For that reason, I'd prefer to not dilute the discussion on this thread to something off topic. Would 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)

    July 19, 2014 at 12:45 pm

    #1730840

  • RE: MAXDOP = 1 ?!

    SQLRNNR (7/18/2014)

    Jeff Moden (7/17/2014)

    From what I've seen, Grant Fritchey's recommendations for changing the default threshold of parallelism are much more effective than changing the whole server to use MAXDOP 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)

    July 18, 2014 at 8:12 am

    #1730631

  • RE: Importing Poorly Formatted Text File

    Ed Wagner (7/18/2014)

    Jeff Moden (7/17/2014)

    Ok. Here we go. Time for some good ol' fashioned "Black Arts". 🙂

    The first thing is, is to understand the true nature of the...

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

    July 18, 2014 at 7:26 am

    #1730597

  • RE: Importing Poorly Formatted Text File

    Koen Verbeeck (7/18/2014)

    Ed Wagner (7/18/2014)

    Koen Verbeeck (7/18/2014)

    Jeff Moden (7/18/2014)

    @Koen,

    Now you see why I never get into SSIS. I just don't need it.

    Everyone has his own tool. I can say...

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

    July 18, 2014 at 7:14 am

    #1730591

  • RE: Convert Rows into Columns

    zbychbor (7/18/2014)

    And next solution:

    regards

    Zbig

    ;with lot(lotNo) as (

    select lotNo

    FROM (VALUES('A'),('B'),('C'),('D'),('E'),('F'),('G'),('H'),('I'),('J'),('K'),('L'),('M'),('N'),('O'),('P'),('Q'),('R'),('S'),('T'),('U'),('V'),('W'),('X'),('Y'),('Z'))t(LotNo)

    )

    , cte02 as (

    select rn = row_number() over (order by lotNo)

    ...

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

    July 18, 2014 at 6:45 am

    #1730577

  • RE: Convert Rows into Columns

    antonio.zerbinati (7/18/2014)

    I dislike the solution proposed, it's far too complicated to reach a so easy task.

    You requirement was to print 3 lots at a time per line of document. 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)

    July 18, 2014 at 6:36 am

    #1730575

  • RE: Convert Rows into Columns

    fregatepllada (7/17/2014)

    Despite all of my protests I have to implement EAV in my current project because some genius :alien: "discovered" this anti-pattern. I do not need to do any aggregation...

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

    July 18, 2014 at 6:21 am

    #1730566

  • RE: Importing Poorly Formatted Text File

    Koen Verbeeck (7/18/2014)

    Jeff Moden (7/18/2014)

    @Koen,

    Now you see why I never get into SSIS. I just don't need it.

    Everyone has his own tool. I can say the same thing about...

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

    July 18, 2014 at 5:22 am

    #1730551

  • RE: Importing Poorly Formatted Text File

    @Koen,

    Now you see why I never get into SSIS. I just don't need it.

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

    July 18, 2014 at 12:00 am

    #1730495

  • RE: Importing Poorly Formatted Text File

    Ok. Here we go. Time for some good ol' fashioned "Black Arts". 🙂

    The first thing is, is to understand the true nature of the data-file example that was...

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

    July 17, 2014 at 11:51 pm

    #1730492

  • RE: MAXDOP = 1 ?!

    From what I've seen, Grant Fritchey's recommendations for changing the default threshold of parallelism are much more effective than changing the whole server to use MAXDOP 1. It keeps...

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

    July 17, 2014 at 8:16 pm

    #1730483

  • RE: T-SQL Pivot Question

    Alan.B (2/7/2014)

    Using the tests below: at a million rows PIVOT generates a parallel plan and is like 4X faster. At 5million they both produce parallel plans and PIVOT is...

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

    July 17, 2014 at 7:55 pm

    #1730481

  • RE: Convert Rows into Columns

    fregatepllada (7/17/2014)

    Thanks Luis, I hate to bring another dimension to performance test but I am using TABLE variable, not temporary table. 😉

    Heh... let me guess... "small row count". 😀

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

    July 17, 2014 at 7:41 pm

    #1730478

Viewing 15 posts - 23,176 through 23,190 (of 59,099 total)