Forum Replies Created

Viewing 15 posts - 38,776 through 38,790 (of 59,072 total)

  • RE: SQL Syntax

    kabaari (4/21/2010)

    Coldcoffee,

    Thanks. Not sure if posting data would apply in this situation. But, I posted data in the past and ended up with people responding with how valuable their time...

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

    April 21, 2010 at 4:30 pm

    #1155756

  • RE: Substring Function in Where Clause

    eseosaoregie (4/21/2010)

    my tables are:

    ---index

    CREATE

    INDEX [IX_FirstFour] ON stg_LogFiles ([Firstfour])

    WITH

    DROP_EXISTING

    ON [PRIMARY]

    ---tables

    CREATE TABLE [stg_LogFiles] (

    [LineRead] [varchar] (100) COLLATE Latin1_General_CI_AS NULL ,

    [Importeddate] [datetime] NULL CONSTRAINT [DF__stg_LogFi__Impor__5441852A] DEFAULT...

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

    April 21, 2010 at 4:26 pm

    #1155752

  • RE: Alter table on-the-fly

    Trybbe (4/21/2010)

    Hi thanks for the feedback, I totaly agree with you but the problem is that changes to the tables are done by a different team from a production side...

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

    April 21, 2010 at 4:20 pm

    #1155748

  • RE: Import only good rows

    My recommendation is to never import directly from any source even if you're the one that built the source... it's an invitation for disaster. Import the data into 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)

    April 21, 2010 at 4:17 pm

    #1155746

  • RE: Determine size of record/row in a table

    Dan Fran (4/21/2010)

    Hello,

    I am curious to know if there is a way to determine the size of a specific row/record in a given table. I know that sqlserver only...

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

    April 21, 2010 at 4:11 pm

    #1155738

  • RE: Hiding payroll data from admin

    Lynn Pettis (4/21/2010)

    Toby White (4/21/2010)

    What system, application, and/or users DO need to see the salary data? If you rely on the SQL engine to decrypt the data, then you cannot...

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

    April 21, 2010 at 4:08 pm

    #1155737

  • RE: Centrally located stored procs?

    Elliott W (4/21/2010)

    bagofbirds-767347 (4/21/2010)

    Lowell - that worked man. awesome!! Thanks so much!

    The rest of you - to answer the main question: i do have a handfull of databases...

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

    April 21, 2010 at 3:54 pm

    #1155728

  • RE: Centrally located stored procs?

    Lowell (4/20/2010)

    i believe if you mark the proc as a system proc, it will do the automagical [currentdbcontext].[dbo].[tablename], instead of looking for the ].[tablename] in master;

    EXECUTE sp_ms_marksystemobject 'sp_test'

    Heh... I'll 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)

    April 21, 2010 at 3:52 pm

    #1155727

  • RE: What do you do when you don't get paid?

    Ninja's_RGR'us (4/21/2010)

    Now the clients wants me to go back as a consultant to keep working on the projects. I refused since it would breach my relationship with my boss...

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

    April 21, 2010 at 3:42 pm

    #1155723

  • RE: MCJ - The Missing Link

    Steve Jones - Editor (4/21/2010)

    I have spoken with my boss, and in principle he thinks it's a good idea to help out here. Any preferences on what you're like 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)

    April 21, 2010 at 2:54 pm

    #1155686

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/21/2010)

    So in summary, Oracle Sucks!

    Thanks for that important safety tip Jeff.

    Heh... I'll probably get slammed by the folks that like Oracle (not slamming them, though), but I worked...

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

    April 21, 2010 at 1:24 pm

    #1155618

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/21/2010)

    Trey Staker (4/21/2010)

    Roy Ernest (4/21/2010)

    GabyYYZ (4/21/2010)

    Please tell me THIS doesn't happen a lot...*groan*.

    I hope it is just a joke....

    I doubt it's a joke. I've seen stuff like...

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

    April 21, 2010 at 11:26 am

    #1155545

  • RE: Are the posted questions getting worse?

    Tom.Thomson (4/20/2010)

    Jeff Moden (4/20/2010)

    Hmmmm... I'd really be interested in the translation for "If you want it real bad, you'll usually get it that way."

    The pun on "bad" doesn't really work...

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

    April 21, 2010 at 11:21 am

    #1155541

  • RE: Today's Random Word!

    Trey Staker (4/21/2010)

    Hibernate

    Heh.... performance problem. 😉

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

    April 21, 2010 at 11:16 am

    #1155537

  • RE: Optimization: Turning a series of entries into columns

    huston.dunlap (4/20/2010)

    Thinking about it more I think what I will do is turn the fields into a semi colon delimited list, getting rid of the duplicate fields.

    Then I can implement...

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

    April 20, 2010 at 8:51 pm

    #1155066

Viewing 15 posts - 38,776 through 38,790 (of 59,072 total)