Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 59,082 total)

  • Reply To: Generation of Auto Series based on logic

    Just for convenience, here's the formula.  Replace the "t.N" with the name of your IDENTITY column that starts at zero.

    CONCAT('10.',CHAR(66+t.N/1000),RIGHT(CONCAT('00',t.N%1000),3))

    EDIT:  Forgot to add that it would be...

    • This reply was modified 3 years, 7 months ago by Jeff Moden.

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

    January 9, 2023 at 7:39 am

    #4135321

  • Reply To: Generation of Auto Series based on logic

    Yes.  And, it's easy.  Start an IDENTITY column at "0".  Add a computed column with the formula from my previous query but replace the "t.N" in both places with 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)

    January 9, 2023 at 7:36 am

    #4135320

  • Reply To: The Time Conversion

    Too funny.  I wish it returned an error instead.  One that says, "Dude!  Just because this is 2022, you shouldn't expect anything different here!" 😀

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

    January 9, 2023 at 7:21 am

    #4135306

  • Reply To: BCP OUT xp_cmdshell errors out maximum column

    I guess I don't understand why you think that you need to list every column.  If you're trying to export the whole table, then export the whole table.

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

    January 7, 2023 at 11:11 pm

    #4134994

  • Reply To: Ethical Hacking Tutorial

    Heh... there's definitely a need for the art.  Here are some folks that prove that...

    https://samcurry.net/web-hackers-vs-the-auto-industry/

    Spooky stuff.

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

    January 7, 2023 at 8:07 am

    #4134844

  • Reply To: The Cost of Employee Turnover

    And then, there are things like this...

    https://www.itprotoday.com/career-development/amazon-slash-more-18000-jobs-escalation-cuts

    I know stuff like this happens but this smacks of poor management and "over-hiring" practices.

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

    January 7, 2023 at 8:03 am

    #4134843

  • Reply To: The Cost of Employee Turnover

    Eddie Wuerch announced on LinkedIn that he got his notification that he'd been laid of from SalesForce when he tried to login.  That's definitely NOT the way to do proper...

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

    January 7, 2023 at 7:11 am

    #4134826

  • Reply To: Generation of Auto Series based on logic

    ScottPletcher wrote:

    Nor trying to be difficult, but that just lists the values, it doesn't assign them as the table ID in the existing table, as stated in the OP.

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

    January 6, 2023 at 11:35 pm

    #4134749

  • Reply To: Generation of Auto Series based on logic

    In order to do what Scott suggests, you'd need to make a SEQUENCE that counts from 1 to 999 and then recycles back to 1.  The formula to convert that...

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

    January 6, 2023 at 10:53 pm

    #4134717

  • Reply To: Generation of Auto Series based on logic

    Just a tiny simplification of what Jonathan posted and it starts with the "B" series like you wanted...

     SELECT TOP 6500
          ...

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

    January 6, 2023 at 10:32 pm

    #4134714

  • Reply To: Parsing XML data into multiple Datasets

    Aye... thanks for posting the link for that.  Much appreciated.

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

    January 6, 2023 at 5:54 pm

    #4134626

  • Reply To: Generation of Auto Series based on logic

    Jeff Moden wrote:

    @ kirti ,

    What do you want it to do when you go to 1 more than 10.Z999 ?

    @ kirti ,

    If you could answer the question above, I can make...

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

    January 6, 2023 at 5:49 pm

    #4134625

  • Reply To: Generation of Auto Series based on logic

    @ kirti ,

    What do you want it to do when you go to 1 more than 10.Z999 ?

     

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

    January 6, 2023 at 3:58 pm

    #4134590

  • Reply To: BCP OUT xp_cmdshell errors out maximum column

    Saran wrote:

    Hi All,

    I am doing BCP out the table having 175 columns. For small table columns it works fine.

    It errors out for this big column table.

    EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT col1...col175...

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

    January 6, 2023 at 3:54 pm

    #4134587

    • Viewing 15 posts - 2,146 through 2,160 (of 59,082 total)