Second insert fails?

[dakone]

 END
        ELSE
            BEGIN

            --Add a new row if customer number doesn't already exist insert new values in the dynamics table RM00101
            INSERT INTO RM00101 (CUSTNMBR, CUSTNAME, ADRSCODE, ADDRESS1, CITY, STATE, COUNTRY, ZIP, PHONE1, FAX, FRSTINDT, CNTCPRSN, PHONE2)
           VALUES (@CUSTNMBR, @CUSTNAME, @ADRSCODE, @ADDRESS1, @CITY, @STATE, @COUNTRY, @ZIP, @PHONE1, @FAX, @FRSTINDT, @CNTCPRSN, 
                            @PHONE2) 

            --Add a new row if customer number doesn't already exist insert new values in the dynamics table RM00102
            INSERT INTO RM00102 (CUSTNMBR, ADRSCODE, ADDRESS1, CITY, STATE, COUNTRY, ZIP, PHONE1, FAX, PHONE2)
            VALUES (@CUSTNMBR, @ADRSCODE, @ADDRESS1, @CITY, @STATE, @COUNTRY, @ZIP, @PHONE1, @FAX, @PHONE2) 

          

            END

 

[SonOfEmidec1100]

Nothing wrong with the sql statement syntax that I can see. Could be something as simple as a miss-spelt field name or different data type in the table - happened to me.

Maybe add PRINT @@error after each insert and run it in query analyzer to see if theres an error ?


Hope this helps

 

[MeanGreen]

When you say the second insert fails, what error are you getting.. or is it just rolling back the changes?