Forum Replies Created

Viewing 15 posts - 16,891 through 16,905 (of 59,067 total)

  • RE: xp_cmdshell Error code: 0x80004005

    Again (and I haven't read back through this entire thread), I hope that you did NOT give a non systemadmin privs to run xp_CmdShell directly.

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

    August 31, 2016 at 9:59 am

    #1898601

  • RE: Avoiding Stored Procedures

    David.Poole (8/31/2016)

    I strongly suspect that developer antipathy to stored procedures is rooted in organisation structure rather than pure technical arguments.

    • Stored procs being seen as a DBA thing taking...

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

    August 31, 2016 at 9:48 am

    #1898594

  • RE: Mortgage amortization table

    Sergiy (8/31/2016)

    But in this case they cannot be blamed.

    They did not create any mess.

    Because there is no mess.

    It's all done right, exactly according to the rules of fixed point computations.

    I'll...

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

    August 31, 2016 at 9:27 am

    #1898586

  • RE: OPENROWSET linked server "(null)" error

    ash_m (8/31/2016)

    Thank you Jeff.

    I tweaked code a bit by introducing a view and it worked!

    I created a view in ash_test procedure which holds the required output data (that way ignored...

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

    August 31, 2016 at 12:39 am

    #1898463

  • RE: Mortgage amortization table

    Sergiy (8/30/2016)

    Jeff Moden (8/29/2016)

    Heh... let's hope the programmers in the IRS aren't using FLOAT to make decisions.

    You better hope they do.

    Why - see below.

    DECLARE @Amount MONEY, @Term INT

    DECLARE @fRate float,...

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

    August 31, 2016 at 12:14 am

    #1898459

  • RE: Mortgage amortization table

    The problem is that MS made the decision to truncate to a scale of 6 whenever the precision of the DECIMAL datatype goes over 38 instead of doing what Granny's...

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

    August 30, 2016 at 11:54 pm

    #1898458

  • RE: OPENROWSET linked server "(null)" error

    ash_m (8/30/2016)

    Hi Jeff,

    Data doesn't get loaded in temp table, fails at EXEC(@tempsql) statement.

    Error:

    Cannot process the object "exec ash_test". The OLE DB provider "SQLNCLI11" for linked server "(null)" indicates that either...

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

    August 30, 2016 at 9:53 pm

    #1898453

  • RE: OPENROWSET linked server "(null)" error

    I've not done a detailed look at your code but it looks like you have pretty much everything covered except the possible problems that may occur with concurrency due 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)

    August 30, 2016 at 9:01 pm

    #1898450

  • RE: Are the posted questions getting worse?

    WayneS (8/29/2016)

    Y.B. (8/29/2016)

    WayneS (8/29/2016)

    jasona.work (8/29/2016)

    Brandie Tarvin (8/29/2016)

    Well my thought is that there are many people who are absolutely terrified of interviews, who don't see themselves doing well no matter what...

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

    August 30, 2016 at 12:39 am

    #1898216

  • RE: OPENROWSET linked server "(null)" error

    ash_m (8/29/2016)

    Hi Jeff,

    Thank you for your reply.

    I've a generic procedure which prints messages on screen and used in validation step in other procedures.

    Ex: Print error message if querying table doesn't...

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

    August 30, 2016 at 12:27 am

    #1898214

  • RE: Mortgage amortization table

    Heh... let's hope the programmers in the IRS aren't using FLOAT to make decisions.

    DECLARE @Amount MONEY, @Term INT

    DECLARE @fRate float, @dRate decimal (38,15)

    SELECT @Amount = 1000000, @Term = 17*3*13*7*19*23*43*11

    SELECT @Term

    SELECT...

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

    August 29, 2016 at 11:36 pm

    #1898209

  • RE: Mortgage amortization table

    Sergiy (8/29/2016)

    Jeff Moden (8/29/2016)

    Someone would have to prove that one to me, Sergiy.

    It took 2 minutes:

    DECLARE @Amount MONEY, @Term INT

    DECLARE @fRate float, @dRate decimal (38,10)

    SELECT @Amount = 1000000, @Term...

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

    August 29, 2016 at 9:18 pm

    #1898205

  • RE: OPENROWSET linked server "(null)" error

    Ah, my apologies. I didn't look at what your code was doing and went only by your description. I thought you were returning something besides the print statement.

    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)

    August 29, 2016 at 8:48 pm

    #1898204

  • RE: Clustered Index Scan or Index Seek + Key Lookup

    VastSQL (8/28/2016)

    GilaMonster (8/28/2016)

    Depends on the table size and number of rows needing a lookup. Test for your data set and see which works better for you.

    Thanks Gail.

    For large data scan...

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

    August 29, 2016 at 7:53 am

    #1898093

  • RE: OPENROWSET linked server "(null)" error

    OPENROWSET returns a result set and only 1 result set. It doesn't know what to do with output from a print statement, which is a separate result set, 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)

    August 29, 2016 at 7:50 am

    #1898092

    • Viewing 15 posts - 16,891 through 16,905 (of 59,067 total)