Hi,
If I try a simple updated e.g.
update referrals set notes = ''
I get the following error
Msg 121, Level 15, State 1
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
If I try a similar simple update on a different table within the same database it works fine.
Any ideas appreciated.
Thanks!
If I try a simple updated e.g.
update referrals set notes = ''
I get the following error
Msg 121, Level 15, State 1
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
If I try a similar simple update on a different table within the same database it works fine.
Any ideas appreciated.
Thanks!