Forum Replies Created

Viewing 15 posts - 50,971 through 50,985 (of 59,091 total)

  • RE: Working with strings

    What is the primary key of the matrix? Also, not that we'll necessarily need it, but can Dynamic SQL be 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)

    April 25, 2008 at 3:31 pm

    #807427

  • RE: querying a string

    GSquared (4/25/2008)

    That's going to work better than spaces around the "like" statement. Of course, if you want it to include "pros" (plural), or "professional"/"professionals", you can add to 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 25, 2008 at 7:58 am

    #807185

  • RE: querying a string

    MarkusB (4/25/2008)

    In order to work correctly, you must surround the source and target with the delimiters in the column... in this case, spaces.

    [font="Courier New"]SELECT myvarcharCol from mytable

    WHERE ' '+myvarcharCol+' '...

    --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 25, 2008 at 7:56 am

    #807184

  • RE: Get rid of Dynamic SQL

    I use this one often...

    [font="Courier New"]...

    ...

    WHERE (@A = AColumn OR @A IS NULL)

    AND (@B = BColumn OR @b-2 IS NULL)

    AND...

    --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 25, 2008 at 7:47 am

    #807180

  • RE: Extracting Rows from Delimited Strings

    Try this... it's Adrian's original code with some conditions added...

    SELECT LEFT(raw_payload, CHARINDEX('+', raw_payload, 1)-1),

    ...

    --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 25, 2008 at 7:41 am

    #807176

  • RE: Extracting Rows from Delimited Strings

    Gus,

    This is an SQL Server 2000 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)

    April 25, 2008 at 7:29 am

    #807163

  • RE: Extracting Rows from Delimited Strings

    Adrian... take a look at the original post... the first entry in the data looks like 'S2009+' which means that you'll get invalid substring messages for the 2 and 3rd...

    --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 25, 2008 at 7:03 am

    #807137

  • RE: Merging Rows with comma

    karthikeyan (4/25/2008)

    I am also thought to use WHILE LOOP.

    Adrian, do you think is there any performance wise difference between using CURSOR and WHILE loop ?

    Please share your thoughts.

    Cursor (with...

    --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 25, 2008 at 7:00 am

    #807134

  • RE: Merging Rows with comma

    karthikeyan (4/25/2008)

    Adrian,

    You are correct. But i don't have the permission to create functions. Can you provide some other alternate ways ?

    You could either ask for the privs or get 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 25, 2008 at 6:57 am

    #807131

  • RE: querying a string

    MarkusB (4/25/2008)

    The most simple option would be using LIKE

    SELECT myvarcharCol from mytable

    WHERE myvarcharCol LIKE '%project%'

    Another option would be using the PATINDEX function

    SELECT myvarcharCol from mytable

    WHERE PATINDEX('project',myvarcharCol) > 0

    Try either 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 25, 2008 at 6:55 am

    #807128

  • RE: T-sql update name fields

    Gary,

    The spaces you're getting is probably because of the data or datatype... For example, are you using CHAR or VARCHAR in the existing table? Are there trailing spaces in...

    --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 25, 2008 at 6:34 am

    #807109

  • RE: While Loop Vs Cursor

    rbarryyoung (4/24/2008)

    I've been out on a job. Sorry for throwing this out there and running, but I hoped it could get you started...

    Jeff Moden (4/24/2008)

    Barry, would you explain why...

    --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 25, 2008 at 6:26 am

    #807104

  • RE: Converting Hexadecimal String Values to Alpha (ASCII) Strings

    I agree that there're a lot of things, like this conversion, that should be done in the GUI instead of SQL Server. Displaying commas in dollar amounts and formatting...

    --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 25, 2008 at 6:20 am

    #807101

  • RE: While Loop Vs Cursor

    I'm sorry... my bad... not enough coffee. I thought you wanted to know what the "N" was (as most frequetly do) and didn't read the rest of the WHERE...

    --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 24, 2008 at 7:47 am

    #806583

  • RE: Identity in descending order

    My appologies... I missed the fact that this is for display purposes...

    You don't need a TempTable nor any form of dynamic SQL for this in SQL 2005... this will 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)

    April 24, 2008 at 7:35 am

    #806572

Viewing 15 posts - 50,971 through 50,985 (of 59,091 total)