Forum Replies Created

Viewing 15 posts - 44,521 through 44,535 (of 59,097 total)

  • RE: how to break phone and exension data

    Nope... bad move on my part... it's going to have to be a function because there's no guarantee that you won't have duplicate phone numbers after the split and that...

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

    March 20, 2009 at 7:55 pm

    #963895

  • RE: how to break phone and exension data

    Ok Shamshad... you've got almost 400 points to your name. That means you've been around long enough to know how to post data for sample data to make 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)

    March 20, 2009 at 7:47 pm

    #963893

  • RE: how to break phone and exension data

    Lowell (3/20/2009)

    ok i think i'm wrong about area codes between 100 and 199(starting with 1), so you might want to remove the logic i put in place to assume 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)

    March 20, 2009 at 7:30 pm

    #963890

  • RE: Hanged on some of the querries do help......

    ""Sameer"" (3/20/2009)

    Hi,

    How to querry a table that will give output like

    1.Atleast one from this and atleast one from other.....

    eg.1.Find the name of each student who has taken...

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

    March 20, 2009 at 6:06 pm

    #963872

  • RE: serial no

    SELECT ROW_NUMBER() OVER (ORDER BY CustomerID) AS SerialNo,

    CustomerId,

    CustomerName

    FROM dbo.CustMaster

    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)

    March 20, 2009 at 5:59 pm

    #963870

  • RE: Numbers table and a join

    Also, there is no need for the highlighted section of the following line of code...

    ON id BETWEEN 0 AND [highlight]ISNULL([/highlight]@Counter[highlight],0)[/highlight]

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

    March 20, 2009 at 5:54 pm

    #963868

  • RE: Hex to Decmial Conversion

    So, how did you manage to prepend the '0x' to the character data to get it to work correctly?

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

    March 20, 2009 at 5:41 pm

    #963864

  • RE: Combining result sets into a single one.

    Any chance of listing the code for EXEC usp_Cash_Trans_pct? I wanna see what's in it that requires the RBAR associated with processing just one sales date at a time.

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

    March 20, 2009 at 5:39 pm

    #963863

  • RE: T-Sql rant

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like 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)

    March 20, 2009 at 5:28 pm

    #963861

  • RE: T-Sql rant

    Michael Valentine Jones (3/20/2009)

    Not that I would ever recommend using this to get the next ID for anything I was designing, but when someone has already put something like this...

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

    March 20, 2009 at 5:27 pm

    #963860

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Derek Dongray (3/20/2009)

    It looks like The Rant has run its course.

    And from his description of his setup (sync software + 3 application tools + 5 databases),...

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

    March 20, 2009 at 4:10 pm

    #963840

  • RE: SQL Server 2005 Paging – The Holy Grail

    Robert Cary (3/14/2009)

    Jeff Moden (3/13/2009)

    Heh... sure... 7 to 8 seconds compared to just over a second. I'm sure your customers will think the same thing while they're waiting. ...

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

    March 20, 2009 at 4:00 pm

    #963835

  • RE: T-Sql rant

    Lynn Pettis (3/20/2009)

    Jeff Moden (3/20/2009)

    Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial code)....

    UPDATE...

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

    March 20, 2009 at 3:53 pm

    #963832

  • RE: Are the posted questions getting worse?

    Must've been named by that guy from MSDN, huh? 😛

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

    March 20, 2009 at 12:21 pm

    #963731

  • RE: BULK INSERT problems

    arun.sas (3/19/2009)

    Hi,

    No need to put the ROWTERMINATOR, when the records in the line ie it row alignment.

    So try to put all row data in one line then second row data...

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

    March 20, 2009 at 11:01 am

    #963693

Viewing 15 posts - 44,521 through 44,535 (of 59,097 total)