every other row appearing from insert into Sql

[wrbodine]

Hi,

Through my asp page, I'm submitting a form to itself and calling a stored procedure to insert some values. When I do this, the first time I try it, nothing shows up in the SQL Server database table. If I try it again, this row shows up in the table, plus the increment of the Primary key (which goes up by one) is 2 higher that the previous row. Where could that other row be going??

Thanks for any input,
Ray

 

[wrbodine]

I found out what was going on; viewing data in a SQL table doesn't necessarily show the data in order, and it was only showing every other row at the bottom of the list; the other records were stored up higher in the list....