I am trying to insert data from one column in one database into a column in another db.
the tables already have the column in place. they both have a unique identifier column (userid) I wrote a little insert statement, but when I try it I get the following error
Msg 512, Level 16, State 1, Procedure trClient_IOIns, Line 20
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

Insert into DB1.dbo.Client (Notes)
Select DB2.dbo.AllNotes.notes
From DB2.dbo.AllNotes inner join
DB1.dbo.Client on Cid=UserID

there are no duplicate userids


thanks

Why are you getting "Procedure trClient_IOIns"? Looks like you might have a trigger in place that may be adding to the fire.

i have no idea, I am looking for any triggers..

OK, now I feel stupid..I should have been using UPDATE not INSERT

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.