Forum Replies Created

Viewing 15 posts - 20,071 through 20,085 (of 59,098 total)

  • RE: Help with joining two tables

    bgolembiesky 4883 (7/26/2015)

    Thanks for taking time to go through this Jeff. ADP assured me that the calculation was performing correctly but it's obviously not. I dumped both tables into excel...

    --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 26, 2015 at 12:43 pm

    #1815013

  • RE: Help with joining two tables

    bgolembiesky 4883 (7/24/2015)

    I've having difficulty joining two tables and getting the results I want. What I'm trying to accomplish is an Health Savings Account (HSA) upload file to go to...

    --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 26, 2015 at 10:40 am

    #1815009

  • RE: is it possible to install sql managment studio on XP?

    As much as I loved XP, XP is no longer supported. You really need to upgrade.

    --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 25, 2015 at 7:57 pm

    #1814984

  • RE: Help with joining two tables

    bgolembiesky 4883 (7/25/2015)

    sgmunson (7/25/2015)

    bgolembiesky 4883 (7/24/2015)

    Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount...

    --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 25, 2015 at 7:56 pm

    #1814983

  • RE: No Downtime Deployments

    WWWWWHHHHUUUUUTTTTT?!?!?!?! You mean to tell me that ORMS don't auto-magically handle all of this? :-P;-)

    And the final comments in that article are only partially correct. If the process...

    --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 25, 2015 at 7:40 pm

    #1814980

  • RE: Getting duplicate data when connecting to another table.

    .Netter (7/25/2015)

    I've just managed to get resolve this, I changed my where statement to look like the following:

    where

    (p.id = @UserId or p.id = @SenderId)

    and

    ...

    --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 25, 2015 at 7:27 pm

    #1814979

  • RE: Help with joining two tables

    bgolembiesky 4883 (7/25/2015)

    sgmunson (7/25/2015)

    bgolembiesky 4883 (7/24/2015)

    Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount...

    --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 25, 2015 at 7:09 pm

    #1814978

  • RE: Is It Worth Writing Unit Tests?

    ZZartin (7/25/2015)

    Just out of curiosity how do people feel about the concept of rapid development as it relates to unit testing since the concept of small individual separate components 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 25, 2015 at 10:01 am

    #1814963

  • RE: Help with joining two tables

    bgolembiesky 4883 (7/24/2015)

    Unfortunately, it does not. That's what I tried initially. It seems like a simple request. All I want is the employee, check date and amount from ps_al_chk_ded where...

    --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 25, 2015 at 9:10 am

    #1814960

  • RE: differential backup

    A "newbie" with just 2 posts had two posts deleted by the automatic SPAM killer because he included URLs in his post. I do wish they'd fix that somehow...

    --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 25, 2015 at 9:07 am

    #1814958

  • RE: Is It Worth Writing Unit Tests?

    David.Poole (7/25/2015)

    I've been looking at the whole business requirements through to deliverable process.

    I used to think I was quite good at testing and peer reviewing code.....until my then company hired...

    --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 25, 2015 at 8:38 am

    #1814957

  • RE: GREATEST and LEAST function

    SQLArnold (7/24/2015)

    Hello All,

    How would you do this with any and all dates?

    I am trying to think of a way to create a Greatest Value that will handle dates, different date...

    --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 25, 2015 at 1:08 am

    #1814942

  • RE: Is It Worth Writing Unit Tests?

    David.Poole (7/24/2015)

    Jeff Moden (7/23/2015)

    Hmmmm.... maybe I'm mistaking what some folks refer to as "unit tests".

    OK bad phraseology. Before TDD type practices.

    I can remember an impassioned debate about the adoption...

    --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 24, 2015 at 6:11 pm

    #1814937

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/24/2015)

    So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a...

    --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 24, 2015 at 11:38 am

    #1814860

  • RE: The Evolving DBA

    Steve Jones - SSC Editor (7/23/2015)

    I find that it seems plenty of companies think a developer or sysadmin can do the job.

    No change there. Look at the posts on...

    --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 23, 2015 at 7:51 pm

    #1814620

Viewing 15 posts - 20,071 through 20,085 (of 59,098 total)