Forum Replies Created

Viewing 15 posts - 49,231 through 49,245 (of 59,099 total)

  • RE: Split data

    That was the recommendation I made above... so, Yes.

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

    July 13, 2008 at 10:27 am

    #842099

  • RE: Validate Date

    It was at least that long ago for me as well... and I could also have a failing memory ...

    I guess the good thing is... we don't have 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)

    July 12, 2008 at 8:25 pm

    #842046

  • RE: ERROR: String o binary data would be truncated

    Uh huh... are those the same executives that think "Bananas in Pajamas" is an appropriate title for a kids' show? :hehe:

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

    July 12, 2008 at 8:05 pm

    #842044

  • RE: Analytical Interview Questions

    Loner (7/12/2008)

    The second one was I had to build a data warehouse. I would get data from different outside sources. Each one would give me a text delimited file...

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

    July 12, 2008 at 11:01 am

    #842010

  • RE: ERROR: String o binary data would be truncated

    Oh, I love those words! "Stuffed up"... I've got an Irish friend at work who says they "buggered it up"... if people only know how nasty those words really...

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

    July 12, 2008 at 10:57 am

    #842008

  • RE: What's an MVP?

    cgnospam (7/12/2008)

    MVP for the most part is a marketing whore.

    There are a lot of companies that do it. They pick pick online "evangelists" on forums and use them 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)

    July 12, 2008 at 10:02 am

    #842000

  • RE: Coming In August

    Heh... as you well know, it doesn't have to be something new to be abused... look at cursors and While loops... look at people storing dates as formatted Varchars... people...

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

    July 12, 2008 at 9:53 am

    #841999

  • RE: Working part-time

    Heh... if you want a part time job that will really keep your skills sharp, get a copy of the Developer's Edition of SQL Server and answer 10,000+ posts on...

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

    July 12, 2008 at 9:48 am

    #841997

  • RE: Split data

    keerthy.vishweshwarachar (7/12/2008)

    Hi,

    This problem arise because we didn't able to read the excel / csv file from ftp location.

    From local server I can read excel / csv file using openrowset function.

    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)

    July 12, 2008 at 9:43 am

    #841996

  • RE: Split data

    Eric Inman (7/11/2008)

    I would get the fire and sword out and demand another tier do this work. My tier CPU is allocated to set based operations. not gross string sex....

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

    July 12, 2008 at 9:30 am

    #841995

  • RE: coalesce negative values

    rbarryyoung (7/11/2008)

    The canonical way to do this is to OR the values to gether and then test the Negative bit (or just test the final result for negative). Unfortunately,...

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

    July 12, 2008 at 9:26 am

    #841994

  • RE: Validate Date

    rbarryyoung (7/11/2008)

    Jeff Moden (7/11/2008)

    rbarryyoung (7/11/2008)

    this was never possible with the old syntax

    That's not true...

    Hey, I just realized... This is the post that you broke 10,000 on! :w00t:

    Woo, hooo! ...

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

    July 12, 2008 at 9:20 am

    #841991

  • RE: Validate Date

    rbarryyoung (7/11/2008)

    Jeff Moden (7/11/2008)

    rbarryyoung (7/11/2008)

    this was never possible with the old syntax

    That's not true...

    rbarryyoung (7/11/2008)

    How's that?

    rbarryyoung (7/11/2008)

    I agree with Lynn.

    Using commas is the older, "SQL-89" syntax and it is deprecated...

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

    July 12, 2008 at 9:15 am

    #841990

  • RE: Can any one tell me what is Common Table Expression in Sql Server

    Skipping all the lectures about the extreme RBAR of recursive CTE's...

    A CTE is the same thing as a Subquery in the FROM clause (Derived table) except that it may 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)

    July 11, 2008 at 7:44 pm

    #841919

  • RE: Database Design for Online Examination System

    vasaharshit (7/11/2008)

    Yes.

    :blink:

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

    July 11, 2008 at 7:42 pm

    #841918

Viewing 15 posts - 49,231 through 49,245 (of 59,099 total)