Forum Replies Created

Viewing 15 posts - 39,766 through 39,780 (of 59,098 total)

  • RE: Repeated questions on forums

    mohammed moinudheen (2/16/2010)

    I have come across several cases where the questions are getting repeated very often on forums.

    Is there anyway this could be avoided. Like if we can maintain an...

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

    February 16, 2010 at 7:50 pm

    #1119782

  • RE: How To insert between Records

    Hamid-Sadeghian (2/16/2010)

    Because in my country the finance organs need to sequence the voucher number.

    for now, i create a temp table and insert all the vouchers into temp table. then select...

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

    February 16, 2010 at 7:43 pm

    #1119779

  • RE: How To insert between Records

    John Esraelo-498130 (2/16/2010)

    hamid, salam.. do not translate farsi to english directly.. because you might confuse the readers..

    if you want you can write in FarsEnglish and I can translate that for...

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

    February 16, 2010 at 7:40 pm

    #1119777

  • RE: How To insert between Records

    John Esraelo-498130 (2/16/2010)

    I think in normal accounting, at least in usa, there is a void process that can cancel.. in fact.. any checking account can handle that therefore it should...

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

    February 16, 2010 at 7:37 pm

    #1119774

  • RE: If Else Statment Syntax Error

    LOOKUP_BI-756009 (2/16/2010)

    Can someone tell me why am I getting error mssg as following

    Msg 156, Level 15, State 1, Line 10

    Incorrect syntax near the keyword 'IF'.

    DECLARE @minutes INT, @word VARCHAR(255),@hours INT,...

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

    February 16, 2010 at 7:14 pm

    #1119767

  • RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

    I'm thinking that it will all boil down to the video card which is likely quite a bit cheaper on the server than on anything else. It takes 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)

    February 16, 2010 at 6:45 pm

    #1119756

  • RE: Hardware Requirements

    I don't have an answer to your good question but you might also want to throw in a note about how many users are going to be hitting this server...

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

    February 16, 2010 at 6:41 pm

    #1119753

  • RE: WILD REPLACE ?

    It does sound like fun. 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)

    February 16, 2010 at 6:34 pm

    #1119748

  • RE: DBCC Timewarp

    Steve Jones - Editor (2/10/2010)

    Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?

    Nah... make that 1920... don't have to look forward 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)

    February 16, 2010 at 5:54 pm

    #1119742

  • RE: WILD REPLACE ?

    C# Screw (2/16/2010)

    Thanks Jeff

    appologies for the delay...

    When I get a moment I might try and build a function that fully supports the PATINDEX sytax.

    I agree with Barry on this... 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)

    February 16, 2010 at 1:10 pm

    #1119488

  • RE: Problem in calculating missing periods

    Thanks for the feedback, Surya. I do recommend that you reconsider the form of your Periods table as I demonstrated. It will likely make your life a lot...

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

    February 16, 2010 at 6:07 am

    #1119219

  • RE: T-SQL Query

    john-902052 (2/15/2010)

    Not sure what you are talking about. I am using 2005 not 2008 SQL Server.

    Hmmm... sorry about that, John. How did you get the INSERT/VALUES statement 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)

    February 16, 2010 at 6:03 am

    #1119217

  • RE: Dealing with a large number of columns

    I wouldn't check just one zip code at a time and I wouldn't split the 24 million row table up. Correctly written queries and joins in the presence 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)

    February 15, 2010 at 8:34 pm

    #1119048

  • RE: Temporal Query Problem

    You should pre-aggregate (thank you Peso) the data by month and status and dump it into a temp table. Then, even the worst performing running total method will work...

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

    February 15, 2010 at 7:30 pm

    #1119046

  • RE: Return dafault values when no rows returned

    Chris,

    Both answers above are technically correct but if you want a coded answer, you'll need to change this...

    Mea Webb t0022165 1 2010-02-15 00:00:00.000 0

    Carlos Banuelos t0021988 1 2010-02-15 00:00:00.000 0

    Vijay...

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

    February 15, 2010 at 7:17 pm

    #1119043

Viewing 15 posts - 39,766 through 39,780 (of 59,098 total)