Forum Replies Created

Viewing 15 posts - 17,926 through 17,940 (of 59,069 total)

  • RE: Sort alphanumeric value based on condition

    Sergiy (4/4/2016)

    Jeff Moden (4/4/2016)

    ,NumPart = CAST(SUBSTRING(ID,1,SplitPos-1) AS INT)

    It will return the same zero value for "0A" and "A".

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

    April 5, 2016 at 9:47 am

    #1869866

  • RE: Processing strings.

    patrickmcginnis59 10839 (4/5/2016)

    Theres already a hodgepodge of tech there, its sort of what Microsoft does

    So why make it more of a hodgepodge? Both C# and VB are good for...

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

    April 5, 2016 at 9:43 am

    #1869861

  • RE: Sort alphanumeric value based on condition

    Just to throw another method in the ring to support Sergiy's idea of normalizing the data on the fly...

    These use the trick of if you specify a length...

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

    April 4, 2016 at 9:42 pm

    #1869704

  • RE: Processing strings.

    So then you agree that there should be no language barriers and that anyone can bring whatever they're comfortable with to any task, correct? Whether I know C# or...

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

    April 4, 2016 at 6:58 pm

    #1869692

  • RE: Today's Random Word!

    TomThomson (4/4/2016)

    Ed Wagner (4/4/2016)

    djj (4/4/2016)

    Manic Star (4/4/2016)

    djj (4/4/2016)

    Grumpy DBA (4/4/2016)

    ZZartin (4/4/2016)

    crookj (4/4/2016)

    ThomasRushton (4/4/2016)

    crookj (4/4/2016)

    Ed Wagner (4/4/2016)

    Grumpy DBA (4/4/2016)

    DonlSimpson (4/4/2016)

    Redsox

    WhiteSox

    Cubs

    Skysox

    SmellySocks

    Deadsox (All zombie team)

    Mutant

    Ninja

    Turtle

    Shell

    Wax

    Car

    Park

    PRNDL

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

    April 4, 2016 at 4:28 pm

    #1869668

  • RE: SSIS connectivity logging into a SQL table

    I'm not an SSIS user but I think even I could make my way through those good instructions. Thanks for taking the time, Jez.

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

    April 4, 2016 at 4:24 pm

    #1869667

  • RE: By date

    Very cool. I love when folks post their search terms. It helps to improve my "Yabingooglewho". 🙂

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

    April 4, 2016 at 4:20 pm

    #1869665

  • RE: Are the posted questions getting worse?

    jasona.work (4/4/2016)

    Ugh...

    We're required to change the passwords on our various service accounts on a regular basis...

    I've got 46 and counting so far to work on...

    Plus migrating to new servers, plus...

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

    April 4, 2016 at 4:17 pm

    #1869663

  • RE: Processing strings.

    You're correct. I mostly can't tell the difference between C# and VB. I was going on what Sachin stated near his code...

    Between I am not a C# expert,...

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

    April 4, 2016 at 3:56 pm

    #1869658

  • RE: Processing strings.

    patrickmcginnis59 10839 (4/4/2016)

    Jeff Moden (4/4/2016)

    patrickmcginnis59 10839 (4/4/2016)

    But whatever floats your boat, if you can't see two inches beyond your TSQL experience, the least you could do is admit that separate...

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

    April 4, 2016 at 2:32 pm

    #1869643

  • RE: help needed with query

    hlsc1983 (4/4/2016)

    got it!

    SELECT scholarship_id , Count(Distinct student_fullname ) as [No of students]

    FROM Students

    Group By scholarship_id

    That's going to be a problem if there's more than one student with the same...

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

    April 4, 2016 at 2:18 pm

    #1869637

  • RE: log for tempdb is full

    coolchaitu (4/4/2016)

    Job failed last night due to temp log consuming full disk space. Could you please advise on fixing this. Heard,Shrinking tempdb log file is not a good idea.

    I don'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)

    April 4, 2016 at 2:06 pm

    #1869630

  • RE: Handling xml data and formatting into separate table

    Eirikur Eiriksson (4/4/2016)

    Jeff Moden (4/4/2016)

    Eirikur Eiriksson (4/4/2016)

    Edit: Just tested 10.000 row elements on my old laptop, finished in less than a second.

    If all the rows were identical, then stats will...

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

    April 4, 2016 at 2:01 pm

    #1869624

  • RE: Sharing data outside company best practices

    Eric M Russell (4/4/2016)

    FTP is a logical choice for providing scheduled data extracts to an external client, especially if they can potentially be more than a handful of MB. 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)

    April 4, 2016 at 1:50 pm

    #1869622

  • RE: Handling xml data and formatting into separate table

    Eirikur Eiriksson (4/4/2016)

    Edit: Just tested 10.000 row elements on my old laptop, finished in less than a second.

    If all the rows were identical, then stats will only have one row...

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

    April 4, 2016 at 12:59 pm

    #1869609

Viewing 15 posts - 17,926 through 17,940 (of 59,069 total)