Forum Replies Created

Viewing 15 posts - 16,756 through 16,770 (of 59,067 total)

  • RE: how to convert navarchar to datetime

    A "SendDate" as an NVARCHAR(4000)? Now that's a table that probably needs to be redesigned a bit. 😉

    --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 21, 2016 at 2:51 pm

    #1902296

  • RE: One to Many relations

    If you want to change a photo in one place, do you want the photo to change in all places that it's used?

    --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 21, 2016 at 2:45 pm

    #1902295

  • RE: Remove duplicates before inserting into destination

    komal145 (9/21/2016)

    The campaignname with date appeneded is duplicates . so , yes to your question.

    example from my table:

    Day10ReminderCampaign2016_09_16_01:43:05

    Day10ReminderCampaign2016_09_17_01:44:01

    Day10ReminderCampaign2016_09_18_01:43:59

    Day10ReminderCampaign2016_09_19_01:45:42

    Day10ReminderCampaign2016_09_20_01:22:18

    Day10ReminderCampaign2016_09_16_01:43:05

    Day10ReminderCampaign2016_09_16_01:43:05

    Day3ReminderCampaign2016_09_16_02:24:16

    Day3ReminderCampaign2016_09_16_02:24:16

    So the eventual problem hasn't been solved. There's no guarantee that two...

    --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 21, 2016 at 1:48 pm

    #1902287

  • RE: The 10X Programmer

    Steve Jones - SSC Editor (9/21/2016)

    10X doesn't mean more code. It doesn't mean more functions or features. It doesn't mean 1/10th the time. It means 10x in terms of effectiveness...

    --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 21, 2016 at 1:43 pm

    #1902284

  • RE: SP inserts into table

    Ken McKelvey (9/21/2016)

    As mentioned, this is an horrible design.

    If you have to live with an app which uses it, I would alter it so the parameters are logged and 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)

    September 21, 2016 at 1:38 pm

    #1902282

  • RE: The 10X Programmer

    djackson 22568 (9/21/2016)

    Jeff Moden (9/21/2016)

    Steve Jones - SSC Editor (9/21/2016)

    Jeff Moden (9/19/2016)

    To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.

    Look in the mirror

    Thank...

    --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 21, 2016 at 1:23 pm

    #1902279

  • RE: The 10X Programmer

    Steve Jones - SSC Editor (9/21/2016)

    Jeff Moden (9/19/2016)

    To be honest, I've yet to run into a supposed 10X programmer that's worth their salt.

    Look in the mirror

    Thank you for the compliment...

    --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 21, 2016 at 12:46 pm

    #1902267

  • RE: Remove duplicates before inserting into destination

    komal145 (9/21/2016)

    Yes. Finally i am able to remove dupes by just getting distinct values from view and inserting into destination.

    What did you do about the question I asked? Did...

    --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 21, 2016 at 12:40 pm

    #1902263

  • RE: Remove duplicates before inserting into destination

    komal145 (9/21/2016)

    My source has duplicate. Campaignnames appened with sendate dupes.

    So my example also contains dupes. In my reference tables , which comes from view over stage/source table has just campaign...

    --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 21, 2016 at 8:27 am

    #1902187

  • RE: The Danger of xp_cmdshell

    Ed Wagner (9/21/2016)

    It's all about picking the right tool for the job. The more tools you have in your toolbox, the more options you have available. If 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)

    September 21, 2016 at 6:21 am

    #1902133

  • RE: Remove duplicates before inserting into destination

    First, with 253 posts, you should know by now to post readily consumable data to get better answers quicker. Please read and heed the first link under "Helpful Links"...

    --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 21, 2016 at 6:15 am

    #1902132

  • RE: Database access via API?

    Your guess is as good as mine. I've not yet heard of such a thing. Do you know the name of the suite or have a source link...

    --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 21, 2016 at 5:21 am

    #1902121

  • RE: Nested Arrays!!

    You would probably do much better posting your C# question on a C# forum.

    --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 20, 2016 at 7:08 pm

    #1902060

  • RE: SP inserts into table

    John Rowan (9/20/2016)

    mcfarlandparkway (9/20/2016)

    I completely agree.This is very horrible code. which was written by old people.

    Even I wonder after seeing this code..

    Old people should not be allowed to write SQL...

    --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 20, 2016 at 5:42 pm

    #1902058

  • RE: SP inserts into table

    mcfarlandparkway (9/20/2016)

    I completely agree.This is very horrible code. which was written by old people.

    Even I wonder after seeing this code..

    Santa is w-a-t-c-h-i-n-g! 😉 Us "old people" wouldn't write...

    --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 20, 2016 at 5:40 pm

    #1902057

Viewing 15 posts - 16,756 through 16,770 (of 59,067 total)