Home Forums SQL Server 2008 T-SQL (SS2K8) Add Total Row For Each Name RE: Add Total Row For Each Name

  • August 30, 2015 at 3:23 pm

    #1823281

    JoseMenendez (8/29/2015)

    The name can be, but will not always be the 2nd word in the string. It will be 1 of 8 names, and if none of those names are found in the string it should be unknown. Does that help make it a little clearer?

    Yes, that makes it more clear but whatever is creating the data knows what's happening and who did it. It would be a thousand times better if the action and the name were created in separate columns by whatever is logging the data... especially since there's likely going to be more than one Mark in the world that could join your company in the future.

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