Forum Replies Created

Viewing 15 posts - 35,401 through 35,415 (of 59,102 total)

  • RE: SQL help needed with a split function sql server 2008

    Sichy (1/13/2011)

    Ahhh yes i see. Thanks again Jeff your help is greatly appreciated!

    JS

    You bet. Thanks for the feedback.

    --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 13, 2011 at 7:25 pm

    #1273386

  • RE: substring funcation.

    mister.magoo (1/13/2011)

    Jeff Moden (1/12/2011)

    I'm a lightweight when it comes to XML. What are the two slashes and the [1] for?

    The two slashes are the XML equivalent of a %...

    --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 13, 2011 at 8:15 am

    #1273076

  • RE: Display name of months in a matrix report

    pwalter83 (1/12/2011)

    Hi Jeff,

    Thanks for your reply. What I want to know is how can I change the format of the date on the SSRS matrix report. I wish to display...

    --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 13, 2011 at 8:13 am

    #1273074

  • RE: UPDATE using a self-join

    GSquared (1/13/2011)[hrUpdate From can have problems if it runs into two or more rows that match the Join/Where criteria and would update one row in the target table. Same...

    --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 13, 2011 at 8:03 am

    #1273067

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    I think that green is an appropriate color for the US

    It would be nice if they kept them Green. Have you seen how much...

    --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 12, 2011 at 9:07 pm

    #1272782

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    As my friend Jeff would say, Bwaa-haa-haa

    BWAA-HAAA!!!! Now THAT's some funny stuff right there. Thanks for the laugh, Steve! 🙂

    --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 12, 2011 at 9:00 pm

    #1272780

  • RE: substring funcation.

    mister.magoo (1/12/2011)

    While we are offering alternatives to the missing function, in this case why not use the xml facilities available?

    DECLARE @exampleString xml

    SET @exampleString = ' <result>failure</result> <reason>invalid Phone1</reason> <leadId>xxxxxxxxxxxx</leadId> <url><![CDATA[https://blahblahblah]]></url>...

    --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 12, 2011 at 8:57 pm

    #1272779

  • RE: Creating a comma-separated list (SQL Spackle)

    WayneS (1/12/2011)

    Jeff Moden (1/12/2011)

    Very cool! Wayne writes an excellent article, Mark provides an excellent performance enhancement in the discussion, and Wayne tests it for everyone. It doesn't get...

    --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 12, 2011 at 8:51 pm

    #1272778

  • RE: Creating a comma-separated list (SQL Spackle)

    WayneS (1/12/2011)

    Mark-101232 (1/12/2011)

    Changing

    value('.','varchar(max)'),1,1,'')

    to

    value('(./text())[1]','varchar(max)'),1,1,'')

    appears to give a better query plan

    Thanks for the information... I'll have to test this out.

    Edit: WOW! What a 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)

    January 12, 2011 at 5:54 pm

    #1272753

  • RE: UPDATE using a self-join

    CELKO (1/12/2011)

    Using BIT is bad and a NULL bit makes no sense. Using the proprietary UPDATE..FROM.. syntax has lots of problems with cardinality and portability.

    I don't care about portability but...

    --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 12, 2011 at 4:37 pm

    #1272726

  • RE: substring funcation.

    BaldingLoopMan (1/11/2011)

    I don’t really need help parsing the data. I was just purposing a question. Why is there no substring function that has a starting position and ending position as...

    --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 12, 2011 at 4:26 pm

    #1272718

  • RE: Temporary variables in SQL

    Also, table variables don't necessarily make things any faster than a Temp Table. They both start out in memory... they both write to disk (TempDB) when they get bigger...

    --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 12, 2011 at 7:16 am

    #1272351

  • RE: How to determine first valid enrollment date

    Heh... it's not as easy as it looks, huh?

    Thank you for setting up the sample data correctly. This should do it for you... the CTE's are named after what...

    --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 11, 2011 at 7:42 pm

    #1272160

  • RE: MCITP advice

    david.alcock (1/11/2011)

    ...and a hello as well to everyone.

    I passed my 070-431 yesterday, absolutely delighted.

    My question is about the upgrade MCITP exam. Im hoping to do 443 &...

    --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 11, 2011 at 7:19 pm

    #1272152

  • RE: Recursive Query to SSIS steps from Raw Data Source

    zahidullislam (1/11/2011)

    Hello,

    Can anyone please help me to (Pseudocode will be perfect) to translate below query to SSIS steps?

    My Data Source is is Raw file and output will be in Raw...

    --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 11, 2011 at 7:17 pm

    #1272150

Viewing 15 posts - 35,401 through 35,415 (of 59,102 total)