Forum Replies Created

Viewing 15 posts - 44,806 through 44,820 (of 59,101 total)

  • RE: Problems sending string parameter to a SP

    That's why I'll frequently use a programmable Tally CTE. I've got that bad boy written up in the Tally table article...

    Thanks for the test code... I'll try to find...

    --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 5, 2009 at 3:58 pm

    #954515

  • RE: "Answered" Posts

    I absolutely agree... right now, there's a "Rate Topic" button in the upper right quadrant of the screen... if you look at the topics in any given week, you might...

    --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 5, 2009 at 3:55 pm

    #954513

  • RE: give me your suggestion

    Bob Hovious (3/5/2009)

    I just tested the function from that article ... it is SLOW!!!!

    9999 rows converted using that function takes almost 20 seconds!!!

    Heh... I absolutely love it... let me officially...

    --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 5, 2009 at 3:07 pm

    #954475

  • RE: "Answered" Posts

    Heh... well said, Bob... my opinion is, "We don' need no stinkin' ratin' system." RTFP instead. 😀

    --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 5, 2009 at 2:38 pm

    #954444

  • RE: "Answered" Posts

    GSquared (3/5/2009)

    Number of posts doesn't assert anything, but it's a better metric than anything subjective.

    Heh... Yeah... especially where I'm concerned... everyone knows I do nothing but write a couple "hunert"...

    --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 5, 2009 at 2:35 pm

    #954436

  • RE: how can i avoid cartesian join?

    Perfect... thanks... here's how to do it...

    ;WITH

    cteTableA AS

    (

    SELECT ROW_NUMBER() OVER (ORDER BY Phone_No) AS RowNumber,

    Phone_No

    FROM dbo.TableA

    ...

    --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 5, 2009 at 2:00 pm

    #954389

  • RE: Find out duplicate rows from multiple table

    SQL_Quest (3/5/2009)

    Jeff Moden (3/4/2009)

    ... and, no... sorry... I don't know how to write a script to do it for 300 different tables auto-magically... no way to know which columns make...

    --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 5, 2009 at 1:45 pm

    #954365

  • RE: A bit of an abstract problem

    Punketal (3/5/2009)

    It was mostly to do with U/I presentational stuff, showing how many had graduated from the school it´s first and last years.

    I solved it with some VB programming so...

    --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 5, 2009 at 1:38 pm

    #954358

  • RE: Sum of previous rows till this row.

    souLTower (3/5/2009)

    Jeff, quick question. Since I used a clustered index couldn't I "assume" that the order would be as I want it?

    I know to never assume...

    ST

    Correct... never assume unless...

    --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 5, 2009 at 1:35 pm

    #954355

  • RE: How generate Dates on the fly

    Jeff Moden (3/5/2009)

    Bob Hovious (3/5/2009)

    JEFF !!!! You don't have a tally table available?

    select dateadd(yy,datediff(yy,0,getdate())-5,0)+ N-1

    from dbo.tally

    where N < datediff(dd,dateadd(yy,datediff(yy,0,getdate())-5,0),getdate())+2

    Runs almost a full millisecond faster at 5-10 years....

    --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 5, 2009 at 1:33 pm

    #954354

  • RE: How generate Dates on the fly

    NY153 (3/5/2009)

    No systables as well 🙁

    And tables available don't have seqeunce numbers. They some id columns, but not perfect.

    Very very limited access

    The sys tables don't need to have any...

    --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 5, 2009 at 1:32 pm

    #954353

  • RE: How generate Dates on the fly

    Bob Hovious (3/5/2009)

    JEFF !!!! You don't have a tally table available?

    select dateadd(yy,datediff(yy,0,getdate())-5,0)+ N-1

    from dbo.tally

    where N < datediff(dd,dateadd(yy,datediff(yy,0,getdate())-5,0),getdate())+2

    Runs almost a full millisecond faster at 5-10 years. 😉

    Pretty...

    --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 5, 2009 at 1:26 pm

    #954350

  • RE: "Answered" Posts

    KevinC. (3/5/2009)

    I really like having the OP state whether a particular answer helped them or not and why. I know it helps me when I'm trying to figure out...

    --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 5, 2009 at 1:24 pm

    #954349

  • RE: How generate Dates on the fly

    Thanks Dugi! Great way to start the day!

    --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 5, 2009 at 6:29 am

    #953974

  • RE: BCP Format File

    Not exactly... post the first 5 rows of one of the data files you intend to import with this and we'll show you how...

    --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 5, 2009 at 6:24 am

    #953971

Viewing 15 posts - 44,806 through 44,820 (of 59,101 total)