Forum Replies Created

Viewing 15 posts - 44,761 through 44,775 (of 59,101 total)

  • RE: PIVOT query

    Bob Hovious (3/6/2009)

    As a former attorney...

    Heh... now I know where you get that wonderful sense of humor... 😀

    --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 7, 2009 at 7:35 am

    #955453

  • RE: Table design

    So, Narendra... are you all set?

    --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 6, 2009 at 10:43 pm

    #955410

  • RE: Bulk insert won't skip the column header in the .csv file

    qzhu (2/5/2009)

    So how should I define my format file to define the column header corretcly? Is there a way to do that?

    There is a nasty little fault in BCP...

    --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 6, 2009 at 10:41 pm

    #955409

  • RE: Repeatable Query

    Shuaib (3/6/2009)

    Thanks lot for you info.

    I also found the Numbers table details.

    If you want to know how a Numbers or Tally table actually works to get jobs like these done,...

    --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 6, 2009 at 10:31 pm

    #955407

  • RE: nth WeekDayName of a month

    robert.mason (3/6/2009)

    Yes, I am using 23:59:59 as the end date for the reports. Any results that occurred after that time are for the following day, and should not be...

    --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 6, 2009 at 10:23 pm

    #955405

  • RE: T-SQL

    metro17 (3/6/2009)

    SELECT MYDATE AS year, DATENAME(mm, MYDATE) AS month, SUM(number) AS totalnumber, SUM(amount)

    AS totalamount

    FROM MYTABLE

    GROUP BY MYDATE, DATENAME(mm, MYDATE)

    ORDER BY MYDATE, DATENAME(mm, MYDATE)

    year month totalnumber totalamount

    2004-08-26 10:39:00 August 2199...

    --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 6, 2009 at 10:14 pm

    #955404

  • RE: sql

    It would likely be better if you wrote the spreadsheet to pull from a view or proc using the "external data" features.

    --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 6, 2009 at 10:06 pm

    #955402

  • RE: PIVOT query

    Bob certainly did that right for the problem given... I'm just concerned about using names which are likely not unique... especially if it's for people's bank accounts. Heh... see...

    --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 6, 2009 at 10:02 pm

    #955400

  • RE: Text Parsing TSQL code

    Larry Trach (3/5/2009)

    Very helpful. Below is a variant that handles space delimited with double quotes around text.

    I have to ask why you would return the columns 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)

    March 6, 2009 at 9:58 pm

    #955399

  • RE: BCP Format File

    Sorry it took me so long to get back to this...

    No... no \t's here... I believe this is what you're looking for. Note that the forum ate 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)

    March 6, 2009 at 9:28 pm

    #955394

  • RE: how can i avoid cartesian join?

    Ya kinda left things hanging here... did that work for you or what? 😉

    --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 6, 2009 at 9:03 pm

    #955390

  • RE: Text Parsing TSQL code

    Douglas De Ivey (10/17/2004)

    No, what you want to do can't be done with SQL2000. You would need to join your 'inpt table' to the output from the function.

    Apparently the next...

    --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 6, 2009 at 8:59 pm

    #955388

  • RE: Question on following sql

    Yep... that's what I do to, Todd... the "habit" I was talking about, though, is the inclusion of the 'U' in the OBJECT_ID function... it's really not necessary.

    --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 6, 2009 at 8:47 pm

    #955387

  • RE: Create a daily record from date ranges

    ...and thank you 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)

    March 6, 2009 at 8:42 pm

    #955386

  • RE: PIVOT query

    Ed (3/6/2009)

    Jeff Moden (3/5/2009)

    I've gotta ask, Ed... why do you need this type of denormalize output? What is that output going to be used on? I'm asking because...

    --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 6, 2009 at 8:31 pm

    #955385

Viewing 15 posts - 44,761 through 44,775 (of 59,101 total)