Columns failing to save data on insert
-
On SQL 7 I wrote a stored procedure which included: Insert tblA A.item1, A.item2,A.item3, ... A.item10,A.item11,A.item12, B.item1,B.item2,B.item3 From tblA A, tblB B Where A.IDcol = @colA And B.IDcol = @colB Everything worked as expected. I generated a script, imported it into another server (which happened to be SQL 2000), and it would not write the last three items when inserting. The fact that the items were coming from another table appears to just be a coincidence. I replaced the final three items with constants and there was still no joy. Finally I wrote an Update to modify the final three items after the insert was completed. The insert itself generated no errors, it just wouldn't write the data. If anyone has seen this kind of problem before, I would sure appreciate knowing the cause and how to avoid it in the future. Thanx... >>>-----> MikeO