Post reply

SQL 2008 - DBA

  • May 21, 2009 at 8:09 pm

    #204484

    Hi all,

    I have a nested stored procedure which bulk inserts data into the table. The problem is sometimes it executes properly and sometimes it just skips it. I dont understand what can be the reason for that.

    Please post your reply ASAP as this is happening on my production server.

    Thanks in advance.

  • May 21, 2009 at 9:13 pm

    #998665

    post the script.........

    Tanx 😀

  • May 21, 2009 at 9:42 pm

    #998668

    You would have to go into more detail. not just the script, but how does the file get there? Is it copied? Perhaps it's not completely copied when the procedure runs.

    Does it not import if you run it manually?

  • May 22, 2009 at 10:43 pm

    #999271

    Thanks for the interest but i think i got the resolution. Thanks for helping ...

  • May 22, 2009 at 11:41 pm

    #999276

    dbpatel.2784 (5/22/2009)

    Thanks for the interest but i think i got the resolution. Thanks for helping ...

    That's good. Forum etiquette, however, says that if you ask for help that you post your resolution even if you fixed the problem yourself. Someone else may have a similar problem and seeing how you resolved your issue may be beneficial to others.

  • May 23, 2009 at 4:13 am

    #999299

    dbpatel.2784 (5/22/2009)

    Thanks for the interest but i think i got the resolution. Thanks for helping ...

    Would be great if you could share the solution please?

  • May 23, 2009 at 10:11 pm

    #999416

    dbpatel.2784 (5/22/2009)

    Thanks for the interest but i think i got the resolution. Thanks for helping ...

    Heh... I'm thinking "Check Valve" right now.

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply