Forum Replies Created

Viewing 15 posts - 26,086 through 26,100 (of 59,099 total)

  • RE: Can you please help me??

    techmarimuthu (8/26/2013)

    I have some doubts in using of loops in sql server 2005

    can you please anyone help me?

    Thanks in advance

    Probably but you need to ask the actual question you have....

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

    August 27, 2013 at 12:59 am

    #1645024

  • RE: Where Statement

    lindavol (8/26/2013)

    THANK YOU - this works when I am in design and go to run

    But does not work when I double click on the report and apply the parameters. ...

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

    August 27, 2013 at 12:54 am

    #1645021

  • RE: Do we have possibility to update system tables in SQL..

    I don't believe you can anymore. Part of the reason is because a lot of people really messed up their systems by updating system tables. What is 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)

    August 27, 2013 at 12:47 am

    #1645019

  • RE: LTRIM,RTRIM

    kk1173 (4/2/2013)

    Its not that simple.

    The team that loads the data will need to clean the data, but they do not want to do it and we do not have...

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

    August 27, 2013 at 12:28 am

    #1645015

  • RE: Log LDF file

    Backups and restores are a wonderful thing but, if the data is THAT important and mistakes in the form of modifications and deletions are made THAT often, then it's 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)

    August 25, 2013 at 9:04 pm

    #1644782

  • RE: Log LDF file

    Deg-235673 (8/25/2013)

    Yes, I've a solution for your problem, and I can say it's possible take a rollback rows straight from the log, you can get in touch with me.

    sincerely Dondeg

    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)

    August 25, 2013 at 8:59 pm

    #1644781

  • RE: String to date conversion issue

    simflex-897410 (8/25/2013)

    However, the issue we have now is that when we try to update same date value, it stores a different formatted value like:

    And now you understand why storing...

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

    August 25, 2013 at 8:51 pm

    #1644780

  • RE: Are the posted questions getting worse?

    GilaMonster (8/25/2013)

    Jeff Moden (8/25/2013)

    GilaMonster (8/25/2013)

    What's your favourite index-related myth?

    What's yours?

    I have a few, but I need fodder for the PASS presentation (that's due today) 😀

    Not necessarily my favorites but here's...

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

    August 25, 2013 at 8:46 pm

    #1644779

  • RE: NULL issue

    Erland Sommarskog (8/25/2013)

    Jeff Moden (8/25/2013)

    I like to have options no matter how infrequently I may use them.

    Having spoken we with a few SQL Server Developers, I know that SET options...

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

    August 25, 2013 at 8:13 pm

    #1644776

  • RE: Are the posted questions getting worse?

    GilaMonster (8/25/2013)

    What's your favourite index-related myth?

    What's yours?

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

    August 25, 2013 at 2:54 pm

    #1644754

  • RE: NULL issue

    Understood but, as you said, users can learn. I view it as another option scheduled for removal, possibly only for the convenience of MS, and I like to have...

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

    August 25, 2013 at 2:40 pm

    #1644749

  • RE: using Sqlpsx functions on a production sql box

    Indianrock (8/24/2013)

    Saving to files with timestamp in the name. The request was to keep error log entries ( other than backup/logon messages ) for a year. I...

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

    August 25, 2013 at 2:23 pm

    #1644747

  • RE: Slow performance on a very small SP that updates a very small table

    There's one other thing that you might actually want to add to the proc if it's ever used by ccalls from the front end.

    SET NOCOUNT ON;

    That will keep...

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

    August 25, 2013 at 2:16 pm

    #1644745

  • RE: CTE to determine Course Level

    pietlinden (8/25/2013)

    LOL, thanks.

    The funny thing was that I figured it out after posting a couple of times. I guess posting forces me to re-read a bunch of my code...

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

    August 25, 2013 at 2:11 pm

    #1644743

  • RE: Another Duplicate removal question

    Lynn Pettis (8/25/2013)

    Jeff Moden (8/24/2013)

    I can't help with requirement #2 because I don't know what your data or table looks like and don't know what exactly you mean by "preferably...

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

    August 25, 2013 at 2:08 pm

    #1644741

Viewing 15 posts - 26,086 through 26,100 (of 59,099 total)