Forum Replies Created

Viewing 15 posts - 38,866 through 38,880 (of 59,072 total)

  • RE: Select a string when data in the string varies

    Hey folks (especially Wayne). I ran into a bit of a buzz saw with the new split function that I previously posted (and have removed from this thread). ...

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

    April 16, 2010 at 6:31 pm

    #1153240

  • RE: Are the posted questions getting worse?

    Heh.... famous last words would be... [font="Arial Black"]AHHHHH CRAP![/font]

    Just so you guys know... remember I said that I changed my cteTally code to use Gianluca's wonderful idea of using UNPIVOT...

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

    April 16, 2010 at 6:22 pm

    #1153236

  • RE: Semi colons

    krypto69 (4/16/2010)

    How can I remove the last semi colon from the list of names that gets created?

    I want the semi colons between the names, just not at the end of...

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

    April 16, 2010 at 3:32 pm

    #1153182

  • RE: Query 5000 Tables for data

    sgj31 (4/16/2010)

    I have a client that has 5000 customers and in the database each customer has a table.

    dbo.Customer1

    dbo.Customer2

    ...

    dbo.Customer5000

    I need an efficient way of reporting on these tables without looping through...

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

    April 16, 2010 at 3:29 pm

    #1153180

  • RE: Continuing Education

    dma-669038 (4/16/2010)

    Or perhaps better put would be - where do you find data to work on?? The majority problems i have enjoyed solving and learnt best are those that are...

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

    April 16, 2010 at 3:06 pm

    #1153162

  • RE: Map IP Address to a Geographical Location

    webrunner (4/16/2010)

    Jeff Moden (7/25/2009)

    Heh... sorry Peter... Thought you were trying to flatten the trajectory of a pork chop for some reason. 😀 I'm a bit touchy because I'm trying...

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

    April 16, 2010 at 12:51 pm

    #1153077

  • RE: Test - ignore this

    Lynn Pettis (4/15/2010)

    Tom Brown (4/15/2010)

    It doesn't work for me - it has worked in the past - but not in the past few weeks

    IE just goes away for ages...

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

    April 16, 2010 at 7:30 am

    #1152824

  • RE: Talking Back

    Brandie Tarvin (4/16/2010)

    Me? I try to keep my personal life out of my blog. I don't want the entire universe to know that I'm a Timelord from...

    Heh... same 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)

    April 16, 2010 at 7:25 am

    #1152813

  • RE: Talking Back

    Brandie Tarvin (4/16/2010)[hrWhereas writing an article takes effort, thinking about the theme, doublechecking your thought processes, ...

    BWAA-HAA! Apparently, some folks don't know the difference. 😀

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

    April 16, 2010 at 7:22 am

    #1152810

  • RE: Continuing Education

    dma-669038 (4/15/2010)

    but I'd like a juicy messed up situation to learn from. How do you create one? Would love to hear more from others in this regard.

    Heh... just read 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)

    April 16, 2010 at 7:17 am

    #1152807

  • RE: Select a string when data in the string varies

    Here's the output from the first bit of code above...

    Date Time ParameterName ParameterValue

    ---------- -------- ------------- -----------------------------------------------------------------------

    2010-04-08 00:00:02 Cmd ...

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

    April 15, 2010 at 9:25 pm

    #1152564

  • RE: Select a string when data in the string varies

    Here's what I was talking about to simplify the split at the "=" sign...

    --=================================================================================================

    -- Test table setup. This is NOT a part of 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)

    April 15, 2010 at 9:15 pm

    #1152561

  • RE: How to find unused Stored Procedures in SQL Server 2005/2008

    First up I start with the SQL Server Profiler with a slightly changed version of the "SP_Counts" template. After my modifications [font="Arial Black"]I have based the template on the "SP:Starting"...

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

    April 15, 2010 at 8:08 pm

    #1152558

  • RE: Talking Back

    It's interesting... SQL Server Central has taken it on the chin a couple of times about the low quality and/or bad information which sometimes appears in its articles because of...

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

    April 15, 2010 at 7:40 pm

    #1152555

  • RE: Talking Back

    awoodhouse (4/15/2010)

    From what i understand of the companies i've worked at, you don't broadcast or discuss company confidential information ever. So in that regard, blogging is already covered. It's already...

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

    April 15, 2010 at 7:20 pm

    #1152554

Viewing 15 posts - 38,866 through 38,880 (of 59,072 total)