Forum Replies Created

Viewing 15 posts - 27,886 through 27,900 (of 59,101 total)

  • RE: Simular to PIVOT Table, but not

    CELKO (12/11/2012)

    You also need to learn ANSI/ISO insertion syntax and to stop using 1970's Sybase dialect:

    Only the first part of that is true. The second part is totally not...

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

    December 12, 2012 at 8:29 am

    #1567916

  • RE: Alternative to xp_cmdshell

    sqlquery-101401 (12/11/2012)

    Superb Jeff, also is there any similar command for copy the files?

    If by "copy files", you mean to import a file to a table, then yes. You can...

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

    December 12, 2012 at 7:38 am

    #1567894

  • RE: Type A, B, or C

    jbnv (12/11/2012)

    And to say that assessing someone's personality is "discrimination" and should be outlawed is an insult both to the researchers who developed these assessments and people who have suffered...

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

    December 11, 2012 at 8:30 am

    #1567470

  • RE: Demanding and difficult logic qns. Sorry but i need help.

    10e5x (12/11/2012)

    Statement 6 will get me my target table. HAHA CRANKY me.

    Is all you want is to build a target table from the query I wrote?

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

    December 11, 2012 at 5:54 am

    #1567400

  • RE: Are the posted questions getting worse?

    jasona.work (12/8/2012)

    Yay dedication...

    :rolleyes:

    You do know the difference between being "loyal" to a company and being "dedicated", right? You have to think "ham and eggs"...

    ... the chicken was "loyal". 😉

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

    December 10, 2012 at 9:16 pm

    #1567239

  • RE: Demanding and difficult logic qns. Sorry but i need help.

    10e5x (12/10/2012)

    Thanks jeff, Haha slowly getting the hang of it. I did a breakdown of your codes and realize it will return me:

    the following error: "The conversion of a char...

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

    December 10, 2012 at 9:12 pm

    #1567238

  • RE: Alternative to xp_cmdshell

    sqlquery-101401 (12/10/2012)

    Thanks much, what is the alternative for reading the file from sql if i dont want to use xp_cmdshell , i am using below

    --Selecting all the backup files from...

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

    December 10, 2012 at 9:08 pm

    #1567237

  • RE: Demanding and difficult logic qns. Sorry but i need help.

    10e5x (12/10/2012)

    Ok i shall work hard to read up more at the moment. will be burning midnight oil, i will be back in a day!;)

    With that kind of attitude, 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)

    December 10, 2012 at 7:30 pm

    #1567231

  • RE: Type A, B, or C

    davoscollective (12/10/2012)

    This is a basic run-down of how it's used.

    1) You tell it about yourself and it gives you a summary.

    2) You then reflect on your summary 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)

    December 10, 2012 at 5:07 pm

    #1567209

  • RE: Memory usage

    GilaMonster (12/10/2012)

    Jeff Moden (12/10/2012)

    In that case, the number of page reads has a direct correlation to the number of and "age" (they empty space may have be inserted 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)

    December 10, 2012 at 4:46 pm

    #1567206

  • RE: Type A, B, or C

    jbnv (12/10/2012)

    Jeff Moden (12/10/2012)

    Ok... how are such profile tests actually useful, then?

    MB in particular provides a somewhat-objective scale for assessing and expressing personality traits, particularly for new hires who haven'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)

    December 10, 2012 at 4:13 pm

    #1567197

  • RE: Type A, B, or C

    jbnv (12/10/2012)

    Jeff Moden (12/10/2012)

    What I'm suggesting is that tests such as MB ... do little in determining if someone will go postal or be an excellent employee.

    Again, that's not 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)

    December 10, 2012 at 12:21 pm

    #1567143

  • RE: Type A, B, or C

    jbnv (12/10/2012)

    Jeff Moden (12/10/2012)

    The problem is that companies ARE, in fact, using them to discriminate.

    And companies discriminate against people who don't know certain programming languages. That's part of doing business:...

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

    December 10, 2012 at 11:54 am

    #1567132

  • RE: Demanding and difficult logic qns. Sorry but i need help.

    Phil Parkin (12/10/2012)

    10e5x (12/10/2012)

    Hi Phil,

    I shall try your approach first since u sounds very confident. And I believe u totally know your stuff. But sad to say, I am not...

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

    December 10, 2012 at 11:51 am

    #1567131

  • RE: Update Gaps

    CELKO (12/10/2012)

    .. why true portability is a myth and I actually hope it always is. If all makes of SQL engines had identical capabilities, there would be no competition...

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

    December 10, 2012 at 11:50 am

    #1567130

Viewing 15 posts - 27,886 through 27,900 (of 59,101 total)