Forum Replies Created

Viewing 15 posts - 48,526 through 48,540 (of 59,099 total)

  • RE: Cursor

    --===== Show first and last PRD and date of each SetSequence

    SELECT yt.SetSequence,

    MAX(CASE WHEN d.MinID = yt.ID THEN PRD END) AS MinPrd,

    ...

    --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 30, 2008 at 11:43 pm

    #865457

  • RE: Using UNION ALL with ORDER BY NEWID()

    Thanks for the feedback, Juan. 🙂

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

    #865456

  • RE: What order do you do maintenance tasks in?

    GilaMonster (8/30/2008)

    balbirsinghsodhi (8/29/2008)

    You can put a shrinking log file as your maintenance plan but never put shrinking database in your maintenance plan.

    It's strongly recommended that neither logs nor data files...

    --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 30, 2008 at 9:20 pm

    #865444

  • RE: Restore with no backup

    Lowell (8/29/2008)

    when you delete a file, regardless of the recycle bin, the file is still there, but the disk space it used is open for use by other programs...if you...

    --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 30, 2008 at 9:16 pm

    #865443

  • RE: Xquery

    Heh... still haven't put that link in your signature line, eh Barry? 😛

    --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 30, 2008 at 9:11 pm

    #865442

  • RE: Using UNION ALL with ORDER BY NEWID()

    The Order BY you have affects the WHOLE query, UNION and all... you need to trick the 2nd query into a standalone query even in the presence of the UNION...

    --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 30, 2008 at 9:05 pm

    #865440

  • RE: Cursor

    simon phoenix (8/30/2008)

    Now only job is to trap the begining and end of those distinct sequence and i think i can do it.

    Missed that... sorry. Easy 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)

    August 30, 2008 at 8:50 pm

    #865439

  • RE: Cursor

    simon phoenix (8/30/2008)

    Hi

    Rog

    You are the SQl Guru, Thanks a lot , i really appreciat it, it was just bugging my head since last week. Now only job is to trap...

    --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 30, 2008 at 8:30 pm

    #865436

  • RE: Cursor

    Heh... ok... my turn. 🙂 And sorry it took me so long to get to this problem...

    First, in order to be fast and short, this fun problem does ...

    --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 30, 2008 at 8:27 pm

    #865435

  • RE: Cursor

    Sorry... My bad... Roger's too. That syntax, starting at ROWS, isn't part of T-SQL in SQL Server 2005.

    --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 30, 2008 at 7:25 pm

    #865432

  • RE: more than one query in CASE-WHEN-THEN statement

    What do you get when you do the following, Gan?

    [font="Courier New"]DECLARE @SomeNumber INT

    SELECT @SomeNumber = Number

    FROM Master.dbo.spt_Values

    SELECT @SomeNumber[/font]

    How many rows were processed? If...

    --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 30, 2008 at 5:47 pm

    #865424

  • RE: Understanding Index defragmentation

    You're talking about "defrag" and then you say "rebuild". Which is it that you are doing?

    --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 30, 2008 at 5:22 pm

    #865420

  • RE: Cursor

    Ummm... I thought Rog gave a solution that didn't include RAC... take a look at his post again. 😉

    --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 30, 2008 at 4:50 pm

    #865418

  • RE: String or binary data would be truncated.

    If execute just the create proc code, you get no errors on creation.

    If you execute the proc in AdventureWorks, you get no run errors.

    What's the problem? 😉

    --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 30, 2008 at 4:48 pm

    #865417

  • RE: swap data between 3 fields?

    Mick,

    You've laid out what you want to do quite nicely. I won't get into the lecture on "normalizing" the data but what is the real data and why do...

    --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 30, 2008 at 4:31 pm

    #865416

Viewing 15 posts - 48,526 through 48,540 (of 59,099 total)