Forum Replies Created

Viewing 15 posts - 52,846 through 52,860 (of 59,098 total)

  • RE: data dictionary tool

    I laughed out loud when I saw your post above, Matt... I do understand that you have to use 20 or 30 pound porkchops to convince people of the right...

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

    January 18, 2008 at 7:31 am

    #769650

  • RE: Combine 2 Text Fields??

    Yeah... I do need to be a jerk about it... you wasted time by not posting in the correct forum and not telling us which version of SQL you were...

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

    January 18, 2008 at 7:20 am

    #769641

  • RE: Member Function Concept.

    Guess I havn't had enough coffee yet, Matt... which 4-letter instruction? Exec?

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

    January 18, 2008 at 7:17 am

    #769638

  • RE: data dictionary tool

    Nice one, Joe...

    Even at that, the problem still remains... if a human doesn't take the time to establish a proper naming convention, proper DRI, and proper table/column commenting, although 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)

    January 18, 2008 at 7:15 am

    #769637

  • RE: SQL6.5,7,2000 and 2005

    Perhaps it's the language barrier, but it looked to me that you wanted us to give you all of the differences between the different versions for you to write your...

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

    January 18, 2008 at 7:06 am

    #769627

  • RE: help-how to generate date backward from end to start

    midan1 (1/18/2008)

    i UNDERSTAND the code

    That's the key... can't really speak for Matt but it was starting to look like you were having him debug every little thing without actually...

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

    January 18, 2008 at 6:59 am

    #769624

  • RE: Performance of Scripts in SQL Server 2000

    Whitt,

    What I really want to know is that, although this was a great exercise for me personally, I did sort of bust a hump to give you a complete high-speed...

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

    January 18, 2008 at 6:49 am

    #769619

  • RE: Performance of Scripts in SQL Server 2000

    Ture enough... and I've not tried the SSIS solution for this, but (just something to consider) the DTS solution was horribly slow compared to the BULK INSERT that used 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)

    January 18, 2008 at 6:47 am

    #769618

  • RE: Member Function Concept.

    For the original problem given where certain parameters determine which function may be exercised and returned, a simple CASE statement would be in order whether it be for a RBAR...

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

    January 18, 2008 at 6:44 am

    #769615

  • RE: How do I increment a DB id

    Ok, thanks, Matt... good information. I'll get my arms around all this "new" 2k5 stuff, soon.

    But I'm pretty sure that Scope_Identity isn't "login" sensitive as you suggest. That...

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

    January 17, 2008 at 10:49 pm

    #769553

  • RE: Simple Query I Need.....

    We'll see... when you figure out the correct answer for the real question being asked, post it here.

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

    January 17, 2008 at 9:56 pm

    #769546

  • RE: data dictionary tool

    Guess the next questions would be...

    How many of you make the mistake of letting developers create their own tables? How many of you allow that to occur without...

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

    January 17, 2008 at 9:50 pm

    #769545

  • RE: Find the missing data

    Step 1... find the person that designed the ID column... take him/her to dinner... feed him/her 2 pound porkchops... at point blank range with a sling shot!

    Ok... having said that,...

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

    January 17, 2008 at 9:42 pm

    #769542

  • RE: Testing

    Heh... let's see... take a urine test, hair test, background check, credit check, education check, check for bounced checks, check for references, check for traffic and felonly violations, etc, etc,...

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

    January 17, 2008 at 9:25 pm

    #769540

  • RE: How do I increment a DB id

    Matt Miller (1/14/2008)

    Since you're in 2005 - you can avoid all of the scope_identity nonsense by using the OUTPUT predicate from within the INSERT statement.

    It looks something like

    declare @nextid as...

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

    January 17, 2008 at 9:17 pm

    #769538

Viewing 15 posts - 52,846 through 52,860 (of 59,098 total)