Forum Replies Created

Viewing 15 posts - 52,576 through 52,590 (of 59,072 total)

  • RE: Compare two Identical tables

    Lookup_BI (2/12/2008)

    but despite many suggestions..My boss[:alien:] is still sticking with his decision.

    Crud... I've been there and done that... having a boss that wears a big ol' chip on his shoulder...

    Sure...

    --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 12, 2008 at 5:29 pm

    #777642

  • RE: Combine 2 Text Fields??

    Heh... perfect...

    --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 12, 2008 at 5:24 pm

    #777641

  • RE: Help with formating

    Greg,

    Would you post one of your emails that has the correct format, please? Be sure to use a code window (Click on "IFCode" in the menu of the edit...

    --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 12, 2008 at 4:53 pm

    #777637

  • RE: TSQL: Computing Balance

    antonio.collins (2/12/2008)

    this particular example is not a pure triangle as illustrated in your article. that's because the 'code' (account number) is used as the primary join article. 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)

    February 12, 2008 at 9:58 am

    #777411

  • RE: Compare two Identical tables

    Yeah, Matt... I was afraid it would be something of that nature... too bad.

    Micheal, I'm right there with you... compromise is to write code to generate static code. Have...

    --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 12, 2008 at 9:51 am

    #777403

  • RE: Compare two Identical tables

    I took a look in BOL for Kishore's suggestion on using tablediff.exe.

    Lemme quote...

    The tablediff command prompt utility returns detailed difference information between two tables and can even generate...

    --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 12, 2008 at 8:00 am

    #777353

  • RE: Bulkinsert

    You have to create a "share" to your directory... the share would be for the user that SQL Server logs in as... OR... if SQL Server was given super user...

    --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 12, 2008 at 7:25 am

    #777338

  • RE: Getting Transaction ID

    felipe (2/12/2008)

    Hi Jeff,

    Please corrrect if I'm making any mistake, but I think SQL creates an unique ID to each opened transaction.

    If it exist, I need to get this ID number.

    Thank...

    --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 12, 2008 at 7:22 am

    #777333

  • RE: Avoid duplicate orders returned

    You had all of that in your first post... obviously, you want some specific format and I'm tired of guessing...

    Would you please type up what you want the output 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 11, 2008 at 9:54 pm

    #777206

  • RE: Avoid duplicate orders returned

    So, what is it that you want to do? You've identified everything but 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)

    February 11, 2008 at 9:35 pm

    #777203

  • RE: sp_executesql hangs for a particular stored procedure

    Instead of doing the FREEPROCCACHE thingy, which affects the whole server, just do a forced recompile in the proc. The other thing this sounds like is "Parameter Sniffing". ...

    --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 11, 2008 at 8:06 pm

    #777195

  • RE: QUERY TUNNING.......

    You bet... let us know how it works out... tuning queries of this nature may take one of the items I listed... or all 6. Maybe even something else......

    --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 11, 2008 at 7:59 pm

    #777192

  • RE: Avoid duplicate orders returned

    Which row do you want to keep for each customer by campaignID?

    Yes i want to keep campaign_id.

    Well.... that's why you're getting the dupes in the results... You have dupes...

    --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 11, 2008 at 7:53 pm

    #777189

  • RE: Shrink Database

    ...AND...

    Until you figure out what made it grow that big to begin with, it's not gonna do you any good to shrink it because the same something is gonna make...

    --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 11, 2008 at 7:44 pm

    #777187

  • RE: How can I execute an external .sql file from a stored procedure?

    If the file width is less than or equal to 255 characters, this is a very easy way to do what you ask...

    [font="Courier New"]CREATE TABLE #MyFile (LineNum INT IDENTITY(1,1), MyText...

    --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 11, 2008 at 7:36 pm

    #777185

Viewing 15 posts - 52,576 through 52,590 (of 59,072 total)