Forum Replies Created

Viewing 15 posts - 34,906 through 34,920 (of 59,102 total)

  • RE: How to solve this 2 query

    daveriya (2/27/2011)

    @jeff,

    well dear,if u dont wanna to help me,just stay out of this matter,i dont mind.

    i am not begging u ,to help me

    thank u

    Heh... first, don't call me "dear". ...

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

    February 27, 2011 at 2:10 pm

    #1292067

  • RE: Error handling

    As of 2005 (IIRC), Bulk Insert (and BCP since way back when) will let you identify an errata file to save errored rows in. You simply tell Bulk Insert...

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

    February 27, 2011 at 2:05 pm

    #1292065

  • RE: Consolidation of table

    daveriya (2/27/2011)

    hi

    How can we check that the consolidated tables were generated correctly?

    Is there any tool in SQL?

    thanks

    You do this by making sure that the code that generated...

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

    February 27, 2011 at 2:01 pm

    #1292064

  • RE: storage and performance issues of using NVarchar(Max)

    This was done as that database pre-allocated space to the size of text blocks indicated, and if defined as 1 block of max 4k chars would be very wasteful 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)

    February 27, 2011 at 1:55 pm

    #1292063

  • RE: ERD Software Needed

    SQL_Student (2/26/2011)

    Any suggestions on a recommended open source software that is fast, simple, and thorough in helping me design a ERD for my database? Thank you

    SQL Server comes with such...

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

    February 27, 2011 at 1:34 pm

    #1292061

  • RE: sql remote access

    I'll also remind folks that SQL Server Standard Edition and Enterprise Editions require Windows Server, as well. SQL Server Express and Developer's Editions will install on the desktop edition...

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

    February 27, 2011 at 1:25 pm

    #1292060

  • RE: Push data from SQL Server to Java Application Server

    A lot of my peers will tell you to use XML for such a thing. I'm not such a big fan of XML because of the overhead involved with...

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

    February 27, 2011 at 1:21 pm

    #1292058

  • RE: How to solve this 2 query

    daveriya (2/27/2011)

    this is not a my hw,and this forum is about to help each other,i m learning so many things.

    and i am learning through this blog

    You have to pardon 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)

    February 27, 2011 at 1:08 pm

    #1292056

  • RE: Programaticaly determine relation between two tables

    Yes, there are a couple of ways although none of them are guaranteed to be correct because of the "human element" during table design.

    You could look for duplicate column names...

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

    February 27, 2011 at 1:00 pm

    #1292054

  • RE: Trim Function help

    rocky_498 (2/26/2011)

    Hi Guys,

    I have question regarding Trim function,

    Here is my requirement,

    Address = ADDRESS1+ADDRESS2+ADDRESS3

    I want to trim if there is no Address1 or Address3

    I know i can use...

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

    February 27, 2011 at 12:34 pm

    #1292052

  • RE: user defined function

    mwwheeler (2/25/2011)

    Ive created a user defined function

    dbo.UDF_ParseNumChars

    when I try to use it in a select statement, its not being recognised

    'UDF_ParseNumChars' is not a recognized built-in function name.

    im trying to execute...

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

    February 27, 2011 at 10:31 am

    #1292046

  • RE: Windowed Function Where Clause

    Simon Davidson (2/27/2011)

    Hi guys,

    Thanks for your responses. Unfortunately the query is for a system that won't be going Live till April. I'm expecting to get some historic data...

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

    February 27, 2011 at 10:16 am

    #1292042

  • RE: How to solve this 2 query

    Craig Farrell (2/25/2011)

    My question, and yes it's a serious one, not just a rant:

    2) At the end of each month, a new table is created for each bank that contains...

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

    February 27, 2011 at 9:43 am

    #1292039

  • RE: SQL & the JOIN Operator

    Paul,

    Isn't this a bit like the article you wrote on designing databases? While I agree with all the things you've stated, entire books have been written on how 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)

    February 27, 2011 at 7:37 am

    #1292034

  • RE: Are the posted questions getting worse?

    WayneS (2/25/2011)

    Jeff Moden (2/25/2011)

    uf curs ah gots ta haz abito funz hurinder too! 😛

    I don't get this 'hurinder" part...

    "Here'n'There". 😛

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

    February 25, 2011 at 8:01 pm

    #1291875

Viewing 15 posts - 34,906 through 34,920 (of 59,102 total)