Forum Replies Created

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

  • 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

  • RE: Working part-time

    abba (7/10/2008)

    I would like to know if anyone works part-time at their job and if so, how did you find such a position?

    I answered a help wanted ad for...

    --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:38 pm

    #841917

  • RE: Split data

    For a 2 dimensional split, see the following...

    http://www.sqlservercentral.com/articles/T-SQL/63003/

    The real problem is going to be how to make a table from that... you will need to use the parameters in...

    --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:35 pm

    #841916

  • RE: Null value is eliminated by an aggregate or other SET operation.

    You don't have to...

    SET ANSI_WARNINGS OFF

    ... will eliminate this expected error message.

    Just to be sure about a couple of things, you might want to post the proc for a...

    --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:22 pm

    #841915

  • RE: Selecting data in a grid?

    I'm in the process of writing a couple of articles on Cross Tabs and Pivots... the more I dig into Pivots, the better I like the ol' classic crosstab. ...

    --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:10 pm

    #841914

  • RE: Query help please!

    You mean a correlated subquery, Grant?

    --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 6:36 pm

    #841911

  • RE: Insert

    Mike Levan (7/11/2008)

    can i do this insert

    INSERT INTO @GroupId, @GroupName, @ZoneInstanceId, @ScoreType

    SELECT ItemId,InspectionItemName,ZoneInstanceId,ScoreTypeId from InspectionGroup

    ORDER BY InspectionItemName

    here InspectionGroup is a CTE

    No... You cannot INSERT into scalar variables... tell us...

    --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 6:34 pm

    #841910

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

    It because you're trying to put something too big into a column too small. It usually means there's an error in the file... might be a transmission error or...

    --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 6:27 pm

    #841909

  • RE: Analytical Interview Questions

    Christopher Stobbs (7/11/2008)

    Thanks for that.

    I'm actually look for more of an Analytical question rather than tech skills questions...

    For example giving them puzzles to see what there approach to problem solving...

    --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 6:13 pm

    #841908

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