Forum Replies Created

Viewing 15 posts - 27,496 through 27,510 (of 59,101 total)

  • RE: Duplicating Certain number of rows

    jwillbanks (2/15/2013)

    I've got a table with shipping information that is grouped by the item shipped and includes several columns of data for each item. What I'm trying to do 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)

    February 15, 2013 at 9:39 am

    #1588386

  • RE: create a function to remove vowels from a given string

    byecoliz (2/15/2013)

    thank you all for that new code. Abu Dina, you're right on the return correction. Now when i do that correction the function removes only the 'A' vowel., meaning...

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

    February 15, 2013 at 9:37 am

    #1588385

  • RE: SQL Developer to SQL DBA

    Abu Dina (2/14/2013)

    mr.neil.bryan (2/14/2013)

    Any tips on making this career change?

    Has anyone done this?

    Many thanks,

    Yup, I made this decision in July last year however, as hard as I tired I couldn'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)

    February 14, 2013 at 11:26 pm

    #1588198

  • RE: SQL Developer to SQL DBA

    ScottPletcher (2/14/2013)

    That's a significant change!

    In order, here's a quick list of the most important things to do first:

    1) Make sure the DBA role will fit you. As a developer,...

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

    February 14, 2013 at 11:07 pm

    #1588196

  • RE: Character '*' in float column

    WARNING! Storing PART NUMBERS as FLOAT will eventually and absolutely screw you to the deck without warning.

    DECLARE @PartNumber FLOAT;

    SELECT @PartNumber = 1234567890123456;

    SELECT @PartNumber AS ScrewedALittle;

    SELECT @PartNumber...

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

    February 14, 2013 at 10:49 pm

    #1588193

  • RE: Bring Solutions

    Competition for jobs gets more intense all the time and the employees that look for problems and provide solutions without being asked will be the most valuable. They will stand...

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

    February 14, 2013 at 10:33 pm

    #1588191

  • RE: Database in Recovery mode from last 7 days.

    Shifting gears, once you get the DB's back up and running, seriously consider upgraded to the latest service pack of SQL Server 2005.

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

    February 13, 2013 at 9:38 pm

    #1587710

  • RE: Are the posted questions getting worse?

    RBarryYoung (2/8/2013)

    Ewww, Tom! I hesitate to ask what "squat thrusts" must mean over there. :sick:

    BWAAAAAAAAA-HAAAAAAA-HAAAAAAA!!!!! (clutching my sides and just blew a half dozen Cheerios out my nose!) ...

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

    February 13, 2013 at 9:31 pm

    #1587709

  • RE: Naming Convention for UDF's, Views and SP's

    ScottPletcher (2/13/2013)

    I wouldn't use a separate schema, first of all because of the security considerations: you'll break the ownership chain, thus forcing a lot more security checks on objects.

    I believe...

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

    February 13, 2013 at 9:19 pm

    #1587707

  • RE: Naming Convention for UDF's, Views and SP's

    Grant Fritchey (2/13/2013)

    I hope no one is shocked when I basically agree with you. I like the concept of grouping through words, but clear language, not embedded codes.

    I'll strongly second...

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

    February 13, 2013 at 9:10 pm

    #1587706

  • RE: Naming Convention for UDF's, Views and SP's

    Grant Fritchey (2/13/2013)

    Ever is probably an over-reaction, but in general these types of naming conventions just don't make sense. How is tblInvoices easier to understand than Invoices? How is it...

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

    February 13, 2013 at 8:39 am

    #1587512

  • RE: Table is not accessible in database

    I strongly recommend that you avoid killing SPIDs if at all possible. Killing a SPID can actually leave it in a permanent 0% rollback that consumes a whole lot...

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

    February 13, 2013 at 6:57 am

    #1587435

  • RE: Help with sorting this recursion

    sku370870 (2/12/2013)

    Hi, and thank you for your answer.

    Following Jeff Moden's answer (and link) - I modified my code to have a sort key that ended up returning...

    \6

    \6\7

    \6\7\12

    \6\7\8

    \6\7\8\13

    ... which seems 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)

    February 12, 2013 at 11:06 pm

    #1587290

  • RE: Puzzle / CTE Help - NO CURORS :)

    Paul White (2/12/2013)

    Hi Colin,

    It's quite easy to go mad trying to do this sort of thing in T-SQL today (future things like ordered aggregates might help, I don't know).

    A cursor...

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

    February 12, 2013 at 8:46 pm

    #1587276

  • RE: Stored procedure explanation

    Sean Lange (2/11/2013)

    DON'T use things you don't need, like the BEGIN and END for the proc itself - completely unneeded and doing nothing but cluttering up the screen.

    Actually begin...

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

    February 11, 2013 at 4:11 pm

    #1586780

Viewing 15 posts - 27,496 through 27,510 (of 59,101 total)