Post reply

stored procedure error

  • June 9, 2005 at 5:32 am

    #564149

    The error is telling you there is a problem with your data.  You are trying to insert Primary Key violations into the system which SQL is politely telling you it won't do.

    What you can do is look at NOT EXISTS or LEFT JOIN for your INSERT statement and only INSERT data you need.  This is a common issue (our batch process goes through it multiple times daily )



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing post 1 (of 2 total)

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