Forum Replies Created

Viewing 15 posts - 41,461 through 41,475 (of 59,067 total)

  • RE: extact last 3 characters from a string

    SALIM ALI (6/18/2009)

    you could try this, it's a bit crude but works...

    declare @string varchar(50)

    SET @string = 'ABCDEFGHIJ123'

    select reverse ( substring ( reverse ( @string ) , 1 , 3 )...

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

    October 18, 2009 at 7:30 pm

    #1067478

  • RE: Scalability and performance?

    Piotr.Rodak (10/18/2009)

    To hire and to consider hiring are two different things Jeff 😉

    Heh... one is a waste of time and effort without the other and both are a waste 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)

    October 18, 2009 at 7:27 pm

    #1067477

  • RE: Division Problem in SQL 2005

    Also, I know it's unnatural, but for the best accuracy, multiply by 100 first, then divide. If you do that, them use 100.0 instead of just 100 and you'll...

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

    October 18, 2009 at 7:22 pm

    #1067475

  • RE: Division Problem in SQL 2005

    robertm-772679 (10/18/2009)

    Thanks for the reply,

    The numbers were just used as an example. I'm really using integer fields as part of the equation and your right, I did not have to...

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

    October 18, 2009 at 7:21 pm

    #1067474

  • RE: BULK INSERT DATE

    I'm not sure that BULK INSERT supports the DATE datatype. I've not been able to find any documentation one way or the other.

    Shifting gears a bit... my recommendation is...

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

    October 18, 2009 at 7:18 pm

    #1067473

  • RE: Add column to subscriber table

    I'm a bit surprised that you could add a column without getting an error about the table being replicated.

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

    October 18, 2009 at 7:04 pm

    #1067470

  • RE: Investing In Your Career

    bitbucket-25253 (10/18/2009)

    Charles Kincaid - let me take you further back onto memory lane, we replaced the 709 with a 1401... Remember when coding was not accomplished with a word processor,...

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

    October 18, 2009 at 6:50 pm

    #1067468

  • RE: A Wish list for the Microsoft Flying Squad

    Gift Peddie's good post brings up a real sore spot with me... why does everyone think that the Agile Manifesto says "[font="Arial Black"]No[/font] Documentation" whatsoever? Why does everyone think...

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

    October 18, 2009 at 6:38 pm

    #1067467

  • RE: Scalability and performance?

    "Yes" or "No" are the wrong answers... for the information given in the original post, the correct answer is "It Depends"... 😉

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

    October 18, 2009 at 6:25 pm

    #1067464

  • RE: alternative for backup/restore for seperate Reporting DB

    Jeffrey Williams-493691 (10/18/2009)

    Jeff - without knowing which SAN it was, it's hard to say what is actually possible.

    Heh... Agreed... Everything is impossible if you don't know what the possibilities 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)

    October 18, 2009 at 6:13 pm

    #1067463

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (10/18/2009)

    Or maybe they've changed the rules now that Jeff isn't serving :-D:-P:w00t:

    Heh... I have been known to have that effect on people. Pork chops anyone?...

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

    October 18, 2009 at 6:08 pm

    #1067461

  • RE: alternative for backup/restore for seperate Reporting DB

    I believe the SAN snapshots we were doing operated kind of like transactional replication where the "clone" was always kept up to date in a parallel fashion. The production...

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

    October 18, 2009 at 10:49 am

    #1067428

  • RE: Afraid of Help

    talltop-969015 (10/17/2009)

    I find it very hard to believe that someone is that clueless that they can't search Google beforehand or find BOL that is installed with SQL Server under 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)

    October 18, 2009 at 10:45 am

    #1067426

  • RE: Concatenating Rows

    And here's a function for items that don't exceed 8K...

    --===== Create a function that uses VARCHAR(8000) with a DUPE Eliminator

    CREATE FUNCTION dbo.Concat8KTestDupElim

    ...

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

    October 18, 2009 at 10:14 am

    #1067422

  • RE: Concatenating Rows

    Min-437192 (10/18/2009)

    Yours is pretty cool, but what do I need to modify if I want to get rid of duplicates? 🙂

    Here's one way that will handle the VARCHAR(MAX)...

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

    October 18, 2009 at 10:04 am

    #1067418

Viewing 15 posts - 41,461 through 41,475 (of 59,067 total)