sql 2k insert into error

microsoft.public.sqlserver.programming

10 Mar 2006 4:18 PM

mecn

hi,

I need to insert records from one table to another in the same database.
INSERT INTO A (field1, field2) Select field1, field2 From B where C='c'

Table A has 5 fields the rest of 3 fields allow null values.

I got error says that Can't insert more than one at a time

I don't want to open cursor.

There is any way to do it?

Thanks

10 Mar 2006 5:34 PM

Scott Morris

> I need to insert records from one table to another in the same database.
> INSERT INTO A (field1, field2) Select field1, field2 From B where C='c'

That is exactly how you should do this. I suspect that there is a poorly
written trigger that is causing the error. In the future, please post the
EXACT error message.