Results 1 to 4 of 4

Thread: Insert problem

  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Unanswered: Insert problem

    Hi friend,

    i am selecting some records from table1 and inserting in to the temp table, in this while selecting some records are coming if i try to insert the same record in to the temp table some other record is inserting i.e some other record from the table1.

    how to resolve this problem

    Thanks
    prabakaran KM

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Make sure no other processes are inserting in the same temptable you are using.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Jun 2010
    Posts
    2

    thanks

    Quote Originally Posted by Martijnvs View Post
    Make sure no other processes are inserting in the same temptable you are using.
    i used top 100 in the select query, i removed the top 100 and set the rowcount as 50 then its work fine

  4. #4
    Join Date
    May 2010
    Location
    Hyderabad, India
    Posts
    16
    Can u pls give me ur queries..
    -PavanKumar M Reddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •